VIEW: APPS.MST_FAC_DOC_CAPACITY_EXCEED_V

Source

View Text - Preformatted

SELECT med.plan_id , med.exception_type , med.exception_detail_id , flp.location_id , flp.facility_id , flp.facility_code , flp.description , substr(mst_wb_util.get_name(med.location_id),1,40) , wl.address1 , wl.city , wl.state , wl.postal_code , wl.country , nvl(flp.num_docks,0) , nvl(med.number1,0) , (nvl(med.number1,0) - nvl(flp.num_docks, 0)) , substr(mst_wb_util.get_local_chardtzone(med.location_id, med.date1),1,40) , substr(mst_wb_util.get_local_chardtzone(med.location_id, med.date2),1,40) , med.date1 , med.date2 , ml.meaning , substr(mst_wb_util.get_threshold_value(med.exception_type),1,20) , substr(mst_wb_util.get_workflow_status(med.plan_id, med.exception_detail_id),1,20) from mst_exception_details med , mfg_lookups ml , wsh_locations wl , fte_location_parameters flp WHERE med.status = ml.lookup_code and ml.lookup_type = 'MST_EXCEPTION_STATUS' and med.location_id = wl.wsh_location_id and med.location_id = flp.location_id

View Text - HTML Formatted

SELECT MED.PLAN_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, FLP.LOCATION_ID
, FLP.FACILITY_ID
, FLP.FACILITY_CODE
, FLP.DESCRIPTION
, SUBSTR(MST_WB_UTIL.GET_NAME(MED.LOCATION_ID)
, 1
, 40)
, WL.ADDRESS1
, WL.CITY
, WL.STATE
, WL.POSTAL_CODE
, WL.COUNTRY
, NVL(FLP.NUM_DOCKS
, 0)
, NVL(MED.NUMBER1
, 0)
, (NVL(MED.NUMBER1
, 0) - NVL(FLP.NUM_DOCKS
, 0))
, SUBSTR(MST_WB_UTIL.GET_LOCAL_CHARDTZONE(MED.LOCATION_ID
, MED.DATE1)
, 1
, 40)
, SUBSTR(MST_WB_UTIL.GET_LOCAL_CHARDTZONE(MED.LOCATION_ID
, MED.DATE2)
, 1
, 40)
, MED.DATE1
, MED.DATE2
, ML.MEANING
, SUBSTR(MST_WB_UTIL.GET_THRESHOLD_VALUE(MED.EXCEPTION_TYPE)
, 1
, 20)
, SUBSTR(MST_WB_UTIL.GET_WORKFLOW_STATUS(MED.PLAN_ID
, MED.EXCEPTION_DETAIL_ID)
, 1
, 20)
FROM MST_EXCEPTION_DETAILS MED
, MFG_LOOKUPS ML
, WSH_LOCATIONS WL
, FTE_LOCATION_PARAMETERS FLP
WHERE MED.STATUS = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'MST_EXCEPTION_STATUS'
AND MED.LOCATION_ID = WL.WSH_LOCATION_ID
AND MED.LOCATION_ID = FLP.LOCATION_ID