Oracle Apps EBS R12 O2C

Oracle Apps EBS R12 Order to Cash cycle with Tab(O2C) Table Flow

Oracle Apps EBS R12 Inventory Table

select * from mtl_system_items_b where segment1 = 'VisionIT O2C Item'

Increase the quantity Tables

select * from mtl_onhand_quantities_detail where INVENTORY_ITEM_ID = '208955'

Oracle Apps EBS R12 Sales Order Tables

select * from oe_order_headers_all where order_number = '66392'

select flow_status_code  from oe_order_headers_all   where order_number = '66392' --

Flow_status_code = Booked

select * from oe_order_lines_all where header_id = '190312'

 

select flow_status_code from oe_order_lines_all  where header_id = '190312' --

Flow_status_code = AWAITING_SHIPPING

select * from wsh_delivery_details where source_header_id = '190312'

select released_status  from wsh_delivery_details where source_header_id = '190312' --- released_status => 'R' =>Ready to Realse

select * from wsh_delivery_assignments where delivery_detail_id = '3961467'

Oracle Apps EBS R12  Release Order Tables

3904028

66392

select * from mtl_txn_request_headers where request_number = '3904028'

select * from mtl_txn_request_lines where header_id = ''

select released_status  from wsh_delivery_details where source_header_id = '190312' --- released_status => 'S' =>Pick Realse

 

select released_status  from wsh_delivery_details where source_header_id = '190312' --- released_status => 'Y' =>Pick Confirm

select * from mtl_reservations where inventory_item_id =

select * from wsh_new_deliveries where delivery_id =

Oracle Apps EBS R12 Ship Confirm Tables

 

select * from oe_order_headers_all where order_number = '66392'

select flow_status_code  from oe_order_headers_all   where order_number = '66392' --

Flow_status_code = Booked

select * from oe_order_lines_all where header_id = '190312'

select flow_status_code from oe_order_lines_all  where header_id = '190312' --

Flow_status_code = AWAITING_SHIPPING

select * from wsh_delivery_details where source_header_id = '190312'

select released_status  from wsh_delivery_details where source_header_id = '190312' --- released_status => 'R' =>Shipped

 

select * from mtl_reservations where inventory_item_id = --- Data Should not be here

select * from mtl_onhand_quantities_detail where INVENTORY_ITEM_ID = '208955'

select * from mtl_material_transactions where INVENTORY_ITEM_ID =

Oracle Apps EBS R12 Interfaced Tables

select * from ra_interface_lines_all where interface_line_attribute1 = '' --- Order num as parameter

Oracle Apps EBS R12 Account Receivable Tables

select * from ra_customer_trx_all where trx_number = ''

select * from ra_customer_trx_lines_all where customer_trx_id = ''

select * from ra_cust_trx_line_gl_dist_all where customer_trx_id = ''

select event_id from ra_cust_trx_line_gl_dist_all where customer_trx_id = ''

 

Oracle Apps EBS R12 SLA Tables

select * from xla_events where event_id =

select * from xla_ae_headers where AE_HEADER_ID =

select * from xla_ae_lines where AE_HEADER_ID =

Oracle Apps EBS R12 General Ledger (GL) Tables

select * from gl_interface where reference26 = '' --- enter ewent_id here

select * from gl_je_batches where name = ''

select * from gl_je_headers where je_batch_id = ''

select * from gl_je_lines where je_header_id = ''

 

Oracle Apps EBS R12 Account Receivable Receipt Tables

select * from ar_cash_receipts_all where receipt_number = ''

select * from ar_cash_receipt_history_all where CASH_RECEIPT_ID = ''

select * from ar_receivable_applications_all where CASH_RECEIPT_ID = ''

select * from ar_payment_schedules_all where cash_receipt_id = ''

Oracle Apps EBS R12 SLA Tables

select * from xla_events where event_id =

select * from xla_ae_headers where AE_HEADER_ID =

select * from xla_ae_lines where AE_HEADER_ID =

 

Oracle Apps EBS R12 General Ledger (GL) Tables

select * from gl_interface where reference26 = '' --- enter ewent_id here

select * from gl_je_batches where name = ''

select * from gl_je_headers where je_batch_id = ''

select * from gl_je_lines where je_header_id = ''