Order to Cash(O2C) Query

select * from oe_order_headers_all where order_number=66782;

select flow_status_code from oe_order_headers_all where order_number='66782';

select * from oe_order_lines_all where header_id=195990;

select * from wsh_new_deliveries where delivery_id=3835372;

select * from wsh_delivery_assignments where delivery_detail_id=4034469;

select * from wsh_delivery_details where source_header_id=192874;

select * from ra_customer_trx_all where ct_reference='66782';

select * from ra_customer_trx_lines_all where customer_trx_id=762706;

select * from ar_receivable_applications_all where applied_customer_trx_id=762706;

select * from ar_cash_Receipts_All where cash_receipt_id=110271;

select event_id from ar_cash_receipt_history_all where cash_receipt_id=110271;

select * from xla_ae_headers where event_id=3381895;

select gl_sl_link_id from xla_ae_lines where ae_header_id=5020977;

select * from xla_events where event_id=3381895;

select * from xla_distribution_links where ae_header_id=5020977;

gl_sl_link_id=6926056;

select je_batch_id from gl_je_headers where je_header_id=4762158;

select * from gl_je_lines where je_header_id=4762158;

select * from gl_je_batches where je_batch_id=3008187;

select * from gl_import_references where gl_sl_link_id=6926056;