O2C TABLE AND LINKS

SELECT * FROM OE_ORDER_HEADERS_ALL WHERE ORDER_NUMBER = 66761


SELECT * FROM OE_ORDER_LINES_ALL WHERE HEADER_ID = 192748 --FLOW_STATUS_CODE


SELECT * FROM OE_PRICE_ADJUSTMENTS WHERE HEADER_ID = 192748


SELECT * FROM WSH_DELIVERY_DETAILS WHERE SOURCE_HEADER_ID = 192748 -- 390591


SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_DETAIL_ID = 4001468




SELECT * FROM MTL_TXN_REQUEST_HEADERS WHERE TRUNC(CREATION_DATE) = TRUNC(SYSDATE)


SELECT * FROM MTL_TXN_REQUEST_LINES WHERE HEADER_ID = 3936071


SELECT *  FROM MTL_MATERIAL_TRANSACTIONS


SELECT * FROM WSH_NEW_DELIVERIES WHERE DELIVERY_ID = '3806373'


SELECT * FROM RA_CUSTOMER_TRX_ALL WHERE INTERFACE_HEADER_ATTRIBUTE1 = '66761' --ORDER NUMBER


SELECT * FROM RA_CUSTOMER_TRX_LINES_ALL WHERE INTERFACE_LINE_ATTRIBUTE1 = '66761'


SELECT * FROM AR_CASH_RECEIPTS_ALL WHERE RECEIPT_NUMBER = '27/02/11'


SELECT * FROM GL_JE_HEADERS WHERE NAME = 'Feb-11 Receipts USD' AND DESCRIPTION = 'Journal Import
 5834434:'


SELECT * FROM GL_JE_LINES WHERE JE_HEADER_ID = 4712212


SELECT * FROM GL_JE_BATCHES WHERE TRUNC(CREATION_DATE) = TRUNC(SYSDATE)


SELECT * FROM GL_BALANCES WHERE LEDGER_ID = 1  AND CODE_COMBINATION_ID =12831 AND PERIOD_YEAR = 2011
AND CURRENCY_CODE = 'USD'


SELECT * FROM GL_CODE_COMBINATIONS


SELECT * FROM GL_BC_PACKETS