VIEW: APPS.AR_TO_SOP_DRILLDOWN_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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