@: O2C Fusion

Oracle Fusion Cloud R13 Tables and Views – Order to Cash table flow

Oracle Fusion Cloud R13 Inventory Tables

SELECT * FROM EGP_SYSTEM_ITEMS_B WHERE DESCRIPTION LIKE ‘ ‘

Oracle Fusion Cloud R13 Sales Order (SO)Tables

SELECT * FROM DOO_HEADERS_ALL WHERE ORDER_NUMBER =

SELECT * FROM DOO_LINES_ALL WHERE HEADER_ID =

SELECT * FROM DOO_FULFILL_LINES_ALL WHERE LINE_ID =

SELECT * FROM WSH_DELIVERY_DETAILS WHERE SOURCE_SHIPMENT_ID =

Oracle Fusion Cloud R13 Interfaced Tables

SELECT * FROM RA_INTERFACE_LINES_ALL WHERE INTERFACE_LINE_ATTRIBUTE1 = '' --- ORDER NUM AS PARAMETER

Oracle Fusion Cloud R13 Account Receivable (AR) 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 Fusion Cloud R13 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 Fusion Cloud R13 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 Fusion Cloud R13 AR 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 = ''