O2C(Order-to-cash) Cycle Tables with Joins

SELECT * FROM OE_ORDER_HEADERS_ALL WHERE ORDER_NUMBER='57088'

SELECT *FROM OE_ORDER_LINES_ALL OOL WHERE OOL.HEADER_ID=96882


SELECT *FROM WSH_NEW_DELIVERIES WHERE DELIVERY_ID=96911

SELECT *FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_DETAIL_ID=247230

SELECT * FROM WSH_DELIVERY_DETAILS WHERE SOURCE_HEADER_ID='96882'

SELECT *FROM WSH_LOOKUPS WHERE LOOKUP_TYPE='DELIVERY_STATUS'

SELECT *FROM WSH_LOOKUPS WHERE LOOKUP_TYPE='PICK_STATUS'


SELECT * FROM RA_INTERFACE_LINES_ALL
WHERE INTERFACE_LINE_ATTRIBUTE1 = '57088'

SELECT * FROM RA_INTERFACE_DISTRIBUTIONS_ALL
WHERE INTERFACE_LINE_ATTRIBUTE1 = '57088'


SELECT *FROM RA_CUSTOMER_TRX_ALL WHERE INTERFACE_HEADER_ATTRIBUTE1='57088' --10021210.

SELECT * FROM RA_CUSTOMER_TRX_LINES_ALL WHERE  CUSTOMER_TRX_ID=210618

SELECT * FROM RA_CUST_TRX_LINE_GL_DIST_ALL WHERE CUSTOMER_TRX_LINE_ID=421425


SELECT *FROM AR_CASH_RECEIPTS_ALL WHERE RECEIPT_NUMBER='57088'

SELECT * FROM AR_RECEIVABLE_APPLICATIONS_ALL
WHERE CASH_RECEIPT_ID = 33495

SELECT * FROM GL_JE_LINES WHERE JE_HEADER_ID=119398 AND JE_LINE_NUM=1

SELECT * FROM GL_JE_LINES
WHERE JE_HEADER_ID = 119395
AND JE_LINE_NUM    = 12

SELECT * FROM RA_CUSTOMER_TRX_ALL
WHERE INTERFACE_HEADER_ATTRIBUTE1 = '57087'