Friday, 26 June 2015

O2C full flow table details in oracle apps

Sales Order
--------------------------------------------------------------------------------
select * from oe_order_headers_all where ORDER_NUMBER='66395'
select * from oe_order_lines_all where HEADER_ID=190357


Book sales order
======================================================================
select * from wsh_delivery_details where SOURCE_HEADER_ID=190357
select * from wsh_delivery_assignments where DELIVERY_DETAIL_ID=3963467


Release Sales order
========================================================================
select * from wsh_picking_batches where ORDER_HEADER_ID=190357
select * from wsh_new_deliveries where DELIVERY_ID=3774372
 
Shipping the Sales order
===================================================================
select * from wsh_delivery_legs where DELIVERY_ID=3774372
select * from wsh_trip_stops where stop_id in(3171666,3171667)
select * from wsh_trips where trip_id=3127351
 
AR INVOICE
===================================================================
select * from ra_customer_trx_all where trunc(creation_date)=trunc(sysdate) and INTERFACE_HEADER_ATTRIBUTE1='66395'


select * from ra_customer_trx_all where TRX_NUMBER='10037514'
select * from ra_customer_trx_lines_all where CUSTOMER_TRX_ID=756901
select * from RA_CUST_TRX_LINE_GL_DIST_ALL where CUSTOMER_TRX_ID=756901
select * from all_tables where table_name like 'AR_RE%'
select * from RA_INTERFACE_LINES_ALL where trunc(creation_date)=trunc(sysdate)
 
Receipts for AR INVOICE
----------------------------------------------------------------------------------
SELECT * FROM AR_CASH_RECEIPTS_ALL WHERE RECEIPT_NUMBER= 'SS1234'
SELECT * FROM AR_RECEIVABLE_APPLICATIONS_ALL WHERE CASH_RECEIPT_ID=109992
select * from ar_cash_receipt_history_all where CASH_RECEIPT_ID=109992
 
 XLA and GL
-----------------------------------------------------------------------------------
 
select je_batch_id from gl_je_headers where trunc(creation_date)=trunc(sysdate)
select je_batch_id from gl_je_headers where je_header_id=4679218
select * from gl_je_batches where je_batch_id=2925233
select GL_SL_LINK_ID from gl_je_lines where je_header_id=4679218
select * from gl_import_references where GL_SL_LINK_ID =6852388
select * from xla_ae_headers where ae_header_id =4946426
select * from xla_ae_lines where gl_sl_link_id= 6852388
select * from xla_transaction_entities_upg where entity_id =3251345
select * from xla_distribution_links where AE_HEADER_ID=4946426
select * from XLA_EVENTS where EVENT_ID=3319807
select * from XLA_TRANSACTION_ENTITIES where TRANSACTION_NUMBER='10037514'
select * from gl_balances where CODE_COMBINATION_ID=125608
select * from gl_code_combinations where CODE_COMBINATION_ID=12833
===============================================================

No comments:

Post a Comment