VIEW: APPS.MRP_PLANNING_EXCEPTION_SETS_V

Source

View Text - Preformatted

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 ,M.SETUP_TIME ,M.UTILIZATION_CHANGE_PERCENT ,M.SETUP_TIME_TYPE ,M.UTILIZATION_CHANGE_TYPE ,L7.MEANING ,L8.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, MFG_LOOKUPS L7, MFG_LOOKUPS L8 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' AND M.SETUP_TIME_TYPE = L7.LOOKUP_CODE AND L7.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD' AND M.UTILIZATION_CHANGE_TYPE = L8.LOOKUP_CODE AND L8.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'

View Text - HTML Formatted

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
, M.SETUP_TIME
, M.UTILIZATION_CHANGE_PERCENT
, M.SETUP_TIME_TYPE
, M.UTILIZATION_CHANGE_TYPE
, L7.MEANING
, L8.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
, MFG_LOOKUPS L7
, MFG_LOOKUPS L8
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'
AND M.SETUP_TIME_TYPE = L7.LOOKUP_CODE
AND L7.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'
AND M.UTILIZATION_CHANGE_TYPE = L8.LOOKUP_CODE
AND L8.LOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'