How data populates in oracle Tables - O2C Flow

--Create Item
Select * from Mtl_system_items_b  where segment1 like' '

--Check On hand Quantity of Item

Select * from Mtl_onhand_quantities_detail  where INVENTORY_ITEM_ID ='2027' --TRANSACTION_QUANTITY

-- Create Sales Order --

--Enter order details
select flow_status_code from Oe_order_headers_all  where ORDER_NUMBER =160000003 ;-- ENTERED
select flow_status_code from Oe_order_lines_all where HEADER_ID =20018 ;-- ENTERED

-- Booked Sales Order

select flow_status_code from Oe_order_headers_all  where ORDER_NUMBER =160000003 ;-- BOOKED
select flow_status_code from Oe_order_lines_all where HEADER_ID =20018 ;-- Awaiting Shipping
select * from wsh_delivery_details where SOURCE_HEADER_ID= 20018 ;-- Delivery id not generated and RELEASED_STATUS = 'R' (Ready to Release)

--Pick Release
select * from wsh_delivery_details where SOURCE_HEADER_ID= 20018 ;-- Delivery id generated and RELEASED_STATUS = 'Y' (Pick Confirm ..there is one more status in between this i.e. S: Pick release)
select * from wsh_new_deliveries where DELIVERY_ID=10009;
select * from mtl_txn_request_headers where REQUEST_NUMBER ='8001' ;--get this value form Concurrent program of Pick release
select * from mtl_txn_request_lines where HEADER_ID='8001'
select * from mtl_reservations where INVENTORY_ITEM_ID='2027' --we will get some data

--Ship Conform
select * from wsh_delivery_details where SOURCE_HEADER_ID= 20018 ;-- RELEASED_STATUS = 'C' (Ready to Release)
select flow_status_code from Oe_order_headers_all  where ORDER_NUMBER =160000003 ;-- BOOKED
select flow_status_code from Oe_order_lines_all where HEADER_ID =20018 ;--Shipped
select * from mtl_reservations where INVENTORY_ITEM_ID='2027'; -- No data
Select * from Mtl_onhand_quantities_detail  where INVENTORY_ITEM_ID ='2027' ;--check quantity
select * from mtl_material_transactions where INVENTORY_ITEM_ID ='2027';

--Auto invoice import
select * from ra_interface_lines_all where INTERFACE_LINE_ATTRIBUTE1 ='160000003'; -- INTERFACE_LINE_ATTRIBUTE1 is Order number
select * from ra_customer_trx_all where TRX_NUMBER ='100021' --TRX_NUMBER is invoice number
select * from ra_customer_trx_lines_all where CUSTOMER_TRX_ID ='56002';
select * from ra_cust_trx_line_gl_dist_all where CUSTOMER_TRX_LINE_ID ='44014';
select event_id from ra_cust_trx_line_gl_dist_all where CUSTOMER_TRX_LINE_ID ='44014';
select * from ar_distributions_all;

--Create Accounting
select * from xla_events where EVENT_ID =56022;
select * from xla_ae_headers where EVENT_ID =56022;
select * from xla_ae_lines where AE_HEADER_ID =13008;
Select * from GL_JE_BATCHES  where NAME like' '; -- Get batch name form concurrent program
Select * from GL_JE_HEADERS  where JE_BATCH_ID=9006;
Select * from GL_JE_LINES  where JE_HEADER_ID =9006;

--Create Receipt
Select * from AR_CASH_RECEIPTS_ALL  where RECEIPT_NUMBER like'CRP2-1'; -- Create receipt manually
Select * from AR_CASH_RECEIPT_HISTORY_ALL  where CASH_RECEIPT_ID=5000;
Select * from AR_RECEIVABLE_APPLICATIONS_ALL where CASH_RECEIPT_ID=5000;
select * from AR_PAYMENT_SCHEDULES_ALL where  CASH_RECEIPT_ID=5000;
select * from ar_distributions_all;
--Create Accounting
select * from xla_events where EVENT_ID =56022;
select * from xla_ae_headers where EVENT_ID =56022;
select * from xla_ae_lines where AE_HEADER_ID =13008;
Select * from GL_JE_BATCHES  where NAME like''; -- Get batch name form concurrent program
Select * from GL_JE_HEADERS  where JE_BATCH_ID=;
Select * from GL_JE_LINES  where JE_HEADER_ID =;