VIEW: APPS.MST_FACILITY_ITEM_INCOMP_V

Source

View Text - Preformatted

SELECT med.plan_id , med.exception_type , med.exception_detail_id , med.delivery_id , med.trip_id1 , med.location_id , mt.mode_of_transport , flp.facility_id , mt.trip_number , flp.facility_code , msikfv.concatenated_segments , msitl.description , decode ( mdd.split_from_delivery_detail_id, null, mdd.sr_delivery_detail_id, mdd.delivery_detail_id ) , md.delivery_number , flp.description , substr ( mst_wb_util.get_name ( med.location_id ), 1, 80 ) , wl.address1 , wl.city , wl.state , wl.postal_code , wl.country , 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 , fte_location_parameters flp , mtl_system_items_kfv msikfv , mtl_system_items_tl msitl , mst_delivery_details mdd , mst_deliveries md , wsh_locations wl , mfg_lookups ml WHERE med.plan_id = mt.plan_id and med.trip_id1 = mt.trip_id and med.location_id = flp.location_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 med.plan_id = md.plan_id and med.delivery_id = md.delivery_id and med.location_id = wl.wsh_location_id and ml.lookup_type = 'MST_EXCEPTION_STATUS' and med.status = ml.lookup_code

View Text - HTML Formatted

SELECT MED.PLAN_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, MED.DELIVERY_ID
, MED.TRIP_ID1
, MED.LOCATION_ID
, MT.MODE_OF_TRANSPORT
, FLP.FACILITY_ID
, MT.TRIP_NUMBER
, FLP.FACILITY_CODE
, MSIKFV.CONCATENATED_SEGMENTS
, MSITL.DESCRIPTION
, DECODE ( MDD.SPLIT_FROM_DELIVERY_DETAIL_ID
, NULL
, MDD.SR_DELIVERY_DETAIL_ID
, MDD.DELIVERY_DETAIL_ID )
, MD.DELIVERY_NUMBER
, FLP.DESCRIPTION
, SUBSTR ( MST_WB_UTIL.GET_NAME ( MED.LOCATION_ID )
, 1
, 80 )
, WL.ADDRESS1
, WL.CITY
, WL.STATE
, WL.POSTAL_CODE
, WL.COUNTRY
, 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
, FTE_LOCATION_PARAMETERS FLP
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, MTL_SYSTEM_ITEMS_TL MSITL
, MST_DELIVERY_DETAILS MDD
, MST_DELIVERIES MD
, WSH_LOCATIONS WL
, MFG_LOOKUPS ML
WHERE MED.PLAN_ID = MT.PLAN_ID
AND MED.TRIP_ID1 = MT.TRIP_ID
AND MED.LOCATION_ID = FLP.LOCATION_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 MED.PLAN_ID = MD.PLAN_ID
AND MED.DELIVERY_ID = MD.DELIVERY_ID
AND MED.LOCATION_ID = WL.WSH_LOCATION_ID
AND ML.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND MED.STATUS = ML.LOOKUP_CODE