View: MRP_PLANNING_EXCEPTION_SETS_V

Product:	MRP - Master Scheduling/MRP
Description:	Planning Exception Set details
Implementation/DBA Data:	APPS.MRP_PLANNING_EXCEPTION_SETS_V

View Text

SELECT M.ROWID ROW_ID
, M.EXCEPTION_SET_NAME
, M.ORGANIZATION_ID
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.EXCESS_QUANTITY
, M.USER_TIME_FENCE
, M.REPETITIVE_VARIANCE
, M.EXCESS_TYPE
, M.OVERPROMISED_TYPE
, M.REP_VARIANCE_TYPE
, M.SHORTAGE_TYPE
, L1.MEANING EXCESS_TEXT
, L2.MEANING OVERPROMISED_TEXT
, L3.MEANING REP_VARIANCE_TEXT
, L4.MEANING SHORTAGE_TEXT
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
, M.OVER_UTILIZED_PERCENT
, M.UNDER_UTILIZED_PERCENT
, M.RESOURCE_SHORTAGE_TYPE
, L5.MEANING
, M.RESOURCE_EXCESS_TYPE
, L6.MEANING
FROM MFG_LOOKUPS L1
, MFG_LOOKUPS L2
, MFG_LOOKUPS L3
, MFG_LOOKUPS L4
, MFG_LOOKUPS L5
, MFG_LOOKUPS L6
, MRP_PLANNING_EXCEPTION_SETS M
WHERE M.EXCESS_TYPE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'
AND M.OVERPROMISED_TYPE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'
AND M.REP_VARIANCE_TYPE = L3.LOOKUP_CODE
AND L3.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'
AND M.SHORTAGE_TYPE = L4.LOOKUP_CODE
AND L4.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'
AND M.RESOURCE_SHORTAGE_TYPE = L5.LOOKUP_CODE
AND L5.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'
AND M.RESOURCE_EXCESS_TYPE = L6.LOOKUP_CODE
AND L6.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'

Columns