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
===============================================================
--------------------------------------------------------------------------------
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