View: MRPBV_PLAN_ITEM_EXCEPTIONS

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPBV_PLAN_ITEM_EXCEPTIONS

View Text

SELECT MIE.COMPILE_DESIGNATOR
, MTP.ORGANIZATION_CODE
, AL.NAME
, ML1.MEANING
, MIE.EXCEPTION_COUNT
, NVL(TO_CHAR(MIE.VERSION)
, ML.MEANING)
, MIE.PLANNING_GROUP
, MIE.ORGANIZATION_ID
, MIE.INVENTORY_ITEM_ID
, MIE.PROJECT_ID
, MIE.TASK_ID
, MIE.DEPARTMENT_ID
, MIE.RESOURCE_ID
, MIE.LINE_ID
, MSI.CATEGORY_ID
, MIE.LAST_UPDATE_DATE
, MIE.LAST_UPDATED_BY
, MIE.CREATION_DATE
, MIE.CREATED_BY
FROM MFG_LOOKUPS ML
, MFG_LOOKUPS ML1
, MTL_PARAMETERS MTP
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_SYSTEM_ITEMS MSI
, MRP_ITEM_EXCEPTIONS MIE
WHERE ML.LOOKUP_TYPE = 'MRP_EXCEPTION_VERSION'
AND ML.LOOKUP_CODE = 1
AND ML1.LOOKUP_TYPE='MRP_EXCEPTION_CODE_TYPE'
AND ML1.LOOKUP_CODE=MIE.EXCEPTION_TYPE
AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR(+)
AND MTP.ORGANIZATION_ID = MIE.ORGANIZATION_ID
AND AL.ORGANIZATION_ID(+) = MIE.ORGANIZATION_ID
AND '_SEC:MIE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns