Product: | GMF - Process Manufacturing Financials |
---|---|
Description: | AR to SOP drilldown view |
Implementation/DBA Data: | APPS.AR_TO_SOP_DRILLDOWN_VIEW |
SELECT DISTINCT OH.ORDER_ID
, OH.ORGN_CODE||OH.ORDER_NO
, OH.ORDER_DATE
, OH.CUSTPO_NO
, OH.ORGN_CODE
, BL.BOL_ID
, BL.ORGN_CODE||BL.BOL_NO
, BL.WAYBILL_NO
, BL.TRAILER_NO
, BL.DEBARKATION_PORT
, BL.EMBARKATION_PORT
, BL.SHIPPER_CODE
, OD.ACTUAL_SHIPDATE
, BS.NAME
, TT.NAME
, CT.TRX_NUMBER
FROM OP_ORDR_HDR OH
, OP_ORDR_DTL OD
, OP_BILL_LAD BL
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES CTL
, RA_BATCH_SOURCES BS
, RA_CUST_TRX_TYPES TT
WHERE CT.BATCH_SOURCE_ID = BS.BATCH_SOURCE_ID
AND TT.CUST_TRX_TYPE_ID = CT.CUST_TRX_TYPE_ID
AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND OD.LINE_ID = CTL.INTERFACE_LINE_ATTRIBUTE1
AND OD.ORDER_ID = OH.ORDER_ID
AND OD.BOL_ID = BL.BOL_ID