VIEW: APPS.MRPBV_PLAN_EXCEPTION_SETS

Source

View Text - Preformatted

SELECT PL.EXCEPTION_SET_NAME , PA.ORGANIZATION_CODE , AL.NAME , PL.EXCESS_QUANTITY , PL.REPETITIVE_VARIANCE , PL.UNDER_UTILIZED_PERCENT , PL.OVER_UTILIZED_PERCENT , PL.USER_TIME_FENCE , '_LA:pl.shortage_type:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING' , '_LA:pl.excess_type:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING' , '_LA:pl.resource_shortage_type:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING' , '_LA:pl.resource_excess_type:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING' , '_LA:pl.overpromised_type:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING' , '_LA:pl.rep_variance_type:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING' , PL.ORGANIZATION_ID , PL.LAST_UPDATE_DATE , PL.LAST_UPDATED_BY , PL.CREATION_DATE , PL.CREATED_BY FROM MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,MRP_PLANNING_EXCEPTION_SETS PL WHERE PL.ORGANIZATION_ID = PA.ORGANIZATION_ID AND PL.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PL.EXCEPTION_SET_NAME
, PA.ORGANIZATION_CODE
, AL.NAME
, PL.EXCESS_QUANTITY
, PL.REPETITIVE_VARIANCE
, PL.UNDER_UTILIZED_PERCENT
, PL.OVER_UTILIZED_PERCENT
, PL.USER_TIME_FENCE
, '_LA:PL.SHORTAGE_TYPE:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING'
, '_LA:PL.EXCESS_TYPE:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING'
, '_LA:PL.RESOURCE_SHORTAGE_TYPE:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING'
, '_LA:PL.RESOURCE_EXCESS_TYPE:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING'
, '_LA:PL.OVERPROMISED_TYPE:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING'
, '_LA:PL.REP_VARIANCE_TYPE:MFG_LOOKUPS:MRP_EXCEPTION_TIME_PERIOD:MEANING'
, PL.ORGANIZATION_ID
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.CREATION_DATE
, PL.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_PLANNING_EXCEPTION_SETS PL
WHERE PL.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND PL.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY