VIEW: APPS.MST_ITEM_MODE_INCOMP_V

Source

View Text - Preformatted

SELECT med.plan_id , med.trip_id1 , mt.planned_flag , med.exception_type , med.exception_detail_id , md.delivery_id , md.planned_flag , wc.carrier_id , mt.trip_number , msikfv.concatenated_segments , msitl.description , mt.mode_of_transport , wlk.meaning , decode ( mdd.split_from_delivery_detail_id, null, mdd.sr_delivery_detail_id, mdd.delivery_detail_id ) , md.delivery_number , wc.freight_code , 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 , mtl_system_items_kfv msikfv , mtl_system_items_tl msitl , wsh_lookups wlk , mst_delivery_details mdd , mst_deliveries md , wsh_carriers wc , mfg_lookups ml WHERE med.plan_id = mt.plan_id and med.trip_id1 = mt.trip_id and med.plan_id = md.plan_id and med.delivery_id = md.delivery_id and med.plan_id = mdd.plan_id and med.delivery_detail_id = mdd.delivery_detail_id and mdd.inventory_item_id = msikfv.inventory_item_id and mdd.organization_id = msikfv.organization_id and mdd.inventory_item_id = msitl.inventory_item_id and mdd.organization_id = msitl.organization_id and msitl.language = userenv('LANG') and wlk.lookup_type = 'WSH_MODE_OF_TRANSPORT' and mt.mode_of_transport = wlk.lookup_code and mt.carrier_id = wc.carrier_id and ml.lookup_type = 'MST_EXCEPTION_STATUS' and med.status = ml.lookup_code

View Text - HTML Formatted

SELECT MED.PLAN_ID
, MED.TRIP_ID1
, MT.PLANNED_FLAG
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, MD.DELIVERY_ID
, MD.PLANNED_FLAG
, WC.CARRIER_ID
, MT.TRIP_NUMBER
, MSIKFV.CONCATENATED_SEGMENTS
, MSITL.DESCRIPTION
, MT.MODE_OF_TRANSPORT
, WLK.MEANING
, DECODE ( MDD.SPLIT_FROM_DELIVERY_DETAIL_ID
, NULL
, MDD.SR_DELIVERY_DETAIL_ID
, MDD.DELIVERY_DETAIL_ID )
, MD.DELIVERY_NUMBER
, WC.FREIGHT_CODE
, 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
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, MTL_SYSTEM_ITEMS_TL MSITL
, WSH_LOOKUPS WLK
, MST_DELIVERY_DETAILS MDD
, MST_DELIVERIES MD
, WSH_CARRIERS WC
, MFG_LOOKUPS ML
WHERE MED.PLAN_ID = MT.PLAN_ID
AND MED.TRIP_ID1 = MT.TRIP_ID
AND MED.PLAN_ID = MD.PLAN_ID
AND MED.DELIVERY_ID = MD.DELIVERY_ID
AND MED.PLAN_ID = MDD.PLAN_ID
AND MED.DELIVERY_DETAIL_ID = MDD.DELIVERY_DETAIL_ID
AND MDD.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID
AND MDD.ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID
AND MDD.INVENTORY_ITEM_ID = MSITL.INVENTORY_ITEM_ID
AND MDD.ORGANIZATION_ID = MSITL.ORGANIZATION_ID
AND MSITL.LANGUAGE = USERENV('LANG')
AND WLK.LOOKUP_TYPE = 'WSH_MODE_OF_TRANSPORT'
AND MT.MODE_OF_TRANSPORT = WLK.LOOKUP_CODE
AND MT.CARRIER_ID = WC.CARRIER_ID
AND ML.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND MED.STATUS = ML.LOOKUP_CODE