VIEW: APPS.MST_CUST_CUST_INCOMP_V

Source

View Text - Preformatted

SELECT med.plan_id , med.exception_type , med.exception_detail_id , mt.trip_id , mt.mode_of_transport , mt.carrier_id , med.customer_id , med.number1 , med.delivery_id , med.number2 , mt.trip_number , wlk.meaning , wc.freight_code , hzp1.party_name , hzp2.party_name , ml.meaning , substr(mst_wb_util.get_workflow_status(med.plan_id, med.exception_detail_id),1,20) from mst_exception_details med , mst_trips mt , mfg_lookups ml , wsh_lookups wlk , hz_parties hzp1 , hz_cust_accounts hca1 , hz_parties hzp2 , hz_cust_accounts hca2 , wsh_carriers wc WHERE med.status = ml.lookup_code and ml.lookup_type = 'MST_EXCEPTION_STATUS' and mt.mode_of_transport = wlk.lookup_code and wlk.lookup_type = 'WSH_MODE_OF_TRANSPORT' and med.plan_id = mt.plan_id and med.trip_id1 = mt.trip_id and med.customer_id = hca1.cust_account_id and hca1.party_id = hzp1.party_id and med.number1 = hca2.cust_account_id and hca2.party_id = hzp2.party_id and mt.carrier_id = wc.carrier_id

View Text - HTML Formatted

SELECT MED.PLAN_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, MT.TRIP_ID
, MT.MODE_OF_TRANSPORT
, MT.CARRIER_ID
, MED.CUSTOMER_ID
, MED.NUMBER1
, MED.DELIVERY_ID
, MED.NUMBER2
, MT.TRIP_NUMBER
, WLK.MEANING
, WC.FREIGHT_CODE
, HZP1.PARTY_NAME
, HZP2.PARTY_NAME
, ML.MEANING
, SUBSTR(MST_WB_UTIL.GET_WORKFLOW_STATUS(MED.PLAN_ID
, MED.EXCEPTION_DETAIL_ID)
, 1
, 20)
FROM MST_EXCEPTION_DETAILS MED
, MST_TRIPS MT
, MFG_LOOKUPS ML
, WSH_LOOKUPS WLK
, HZ_PARTIES HZP1
, HZ_CUST_ACCOUNTS HCA1
, HZ_PARTIES HZP2
, HZ_CUST_ACCOUNTS HCA2
, WSH_CARRIERS WC
WHERE MED.STATUS = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND MT.MODE_OF_TRANSPORT = WLK.LOOKUP_CODE
AND WLK.LOOKUP_TYPE = 'WSH_MODE_OF_TRANSPORT'
AND MED.PLAN_ID = MT.PLAN_ID
AND MED.TRIP_ID1 = MT.TRIP_ID
AND MED.CUSTOMER_ID = HCA1.CUST_ACCOUNT_ID
AND HCA1.PARTY_ID = HZP1.PARTY_ID
AND MED.NUMBER1 = HCA2.CUST_ACCOUNT_ID
AND HCA2.PARTY_ID = HZP2.PARTY_ID
AND MT.CARRIER_ID = WC.CARRIER_ID