VIEW: APPS.MRPFV_PLAN_ITEM_EXCEPTIONS

Source

View Text - Preformatted

SELECT MIE.COMPILE_DESIGNATOR , MTP.ORGANIZATION_CODE , AL.NAME , ML1.MEANING , MIE.EXCEPTION_COUNT , NVL(TO_CHAR(MIE.VERSION), ML.MEANING) , '_KF:INV:MSTK:SYSITEM' , '_KF:INV:MCAT:MTLCAT' , MSI.PLANNER_CODE , MSI.BUYER_NAME , MIE.PLANNING_GROUP , MRP_GET_PROJECT.PROJECT(MIE.PROJECT_ID) , MRP_GET_PROJECT.TASK(MIE.TASK_ID) , LINE.LINE_CODE , DEPT.DEPARTMENT_CODE , RES.RESOURCE_CODE , ML2.MEANING , 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 ,MFG_LOOKUPS ML2 ,MTL_PARAMETERS MTP ,HR_ALL_ORGANIZATION_UNITS AL ,MTL_SYSTEM_ITEMS SYSITEM ,MTL_CATEGORIES MTLCAT ,MRP_SYSTEM_ITEMS MSI ,BOM_DEPARTMENTS DEPT ,BOM_RESOURCES RES ,WIP_LINES LINE ,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 ML2.LOOKUP_TYPE(+)='BOM_RESOURCE_TYPE' AND ML2.LOOKUP_CODE(+)=RES.RESOURCE_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 MTLCAT.CATEGORY_ID(+) = MSI.CATEGORY_ID AND SYSITEM.INVENTORY_ITEM_ID(+) = MIE.INVENTORY_ITEM_ID AND SYSITEM.ORGANIZATION_ID(+) = MIE.ORGANIZATION_ID AND MTP.ORGANIZATION_ID = MIE.ORGANIZATION_ID AND AL.ORGANIZATION_ID(+) = MIE.ORGANIZATION_ID AND DEPT.DEPARTMENT_ID(+)= MIE.DEPARTMENT_ID AND RES.RESOURCE_ID(+)=MIE.RESOURCE_ID AND LINE.LINE_ID(+)=MIE.LINE_ID AND LINE.ORGANIZATION_ID(+) = MIE.ORGANIZATION_ID AND '_SEC:MIE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MIE.COMPILE_DESIGNATOR
, MTP.ORGANIZATION_CODE
, AL.NAME
, ML1.MEANING
, MIE.EXCEPTION_COUNT
, NVL(TO_CHAR(MIE.VERSION)
, ML.MEANING)
, '_KF:INV:MSTK:SYSITEM'
, '_KF:INV:MCAT:MTLCAT'
, MSI.PLANNER_CODE
, MSI.BUYER_NAME
, MIE.PLANNING_GROUP
, MRP_GET_PROJECT.PROJECT(MIE.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MIE.TASK_ID)
, LINE.LINE_CODE
, DEPT.DEPARTMENT_CODE
, RES.RESOURCE_CODE
, ML2.MEANING
, 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
, MFG_LOOKUPS ML2
, MTL_PARAMETERS MTP
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SYSITEM
, MTL_CATEGORIES MTLCAT
, MRP_SYSTEM_ITEMS MSI
, BOM_DEPARTMENTS DEPT
, BOM_RESOURCES RES
, WIP_LINES LINE
, 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 ML2.LOOKUP_TYPE(+)='BOM_RESOURCE_TYPE'
AND ML2.LOOKUP_CODE(+)=RES.RESOURCE_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 MTLCAT.CATEGORY_ID(+) = MSI.CATEGORY_ID
AND SYSITEM.INVENTORY_ITEM_ID(+) = MIE.INVENTORY_ITEM_ID
AND SYSITEM.ORGANIZATION_ID(+) = MIE.ORGANIZATION_ID
AND MTP.ORGANIZATION_ID = MIE.ORGANIZATION_ID
AND AL.ORGANIZATION_ID(+) = MIE.ORGANIZATION_ID
AND DEPT.DEPARTMENT_ID(+)= MIE.DEPARTMENT_ID
AND RES.RESOURCE_ID(+)=MIE.RESOURCE_ID
AND LINE.LINE_ID(+)=MIE.LINE_ID
AND LINE.ORGANIZATION_ID(+) = MIE.ORGANIZATION_ID
AND '_SEC:MIE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY