VIEW: APPS.MRP_ITEM_EXCEPTION_V

Source

View Text - Preformatted

SELECT MIE.EXCEPTION_TYPE , ML1.MEANING , MIE.COMPILE_DESIGNATOR , MIE.ORGANIZATION_ID , MIE.PROJECT_ID , MIE.TASK_ID , MIE.VERSION , nvl(to_char(MIE.VERSION), ml.meaning) , MIE.EXCEPTION_COUNT , MIE.INVENTORY_ITEM_ID , MSI.PLANNER_CODE , MSI.CATEGORY_ID , MIE.PLANNING_GROUP , MIF.ITEM_NUMBER , MTP.ORGANIZATION_CODE , MRP_GET_PROJECT.PROJECT(MIE.PROJECT_ID) , MRP_GET_PROJECT.TASK(MIE.TASK_ID) , MSI.BUYER_NAME , MIE.DEPARTMENT_ID , MIE.RESOURCE_ID , MIE.LINE_ID , to_char(null) , to_char(null) ,LINE.LINE_CODE ,to_number(null) ,to_char(null) , MIE.DISPLAY , MIE.ROWID FROM MFG_LOOKUPS ML, MFG_LOOKUPS ML1, MTL_PARAMETERS MTP, MTL_ITEM_FLEXFIELDS MIF, MRP_SYSTEM_ITEMS MSI, 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 MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR AND MIF.ITEM_ID = MIE.INVENTORY_ITEM_ID AND MIF.ORGANIZATION_ID = MIE.ORGANIZATION_ID AND MTP.ORGANIZATION_ID = MIE.ORGANIZATION_ID AND MIE.RESOURCE_ID = -1 AND LINE.LINE_ID(+)=MIE.LINE_ID AND MIE.DISPLAY=1 UNION ALL SELECT MIE.EXCEPTION_TYPE , ML1.MEANING , MIE.COMPILE_DESIGNATOR , MIE.ORGANIZATION_ID , MIE.PROJECT_ID , MIE.TASK_ID , MIE.VERSION , nvl(to_char(MIE.VERSION), ml.meaning) , MIE.EXCEPTION_COUNT , MIE.INVENTORY_ITEM_ID , to_char(NULL) , to_number(null) , MIE.PLANNING_GROUP , NULL , MTP.ORGANIZATION_CODE , MRP_GET_PROJECT.PROJECT(MIE.PROJECT_ID) , MRP_GET_PROJECT.TASK(MIE.TASK_ID) , to_char(null) , MIE.DEPARTMENT_ID , MIE.RESOURCE_ID , MIE.LINE_ID , DEPT.DEPARTMENT_CODE , RES.RESOURCE_CODE ,LINE.LINE_CODE ,RES.RESOURCE_TYPE ,ML2.MEANING , MIE.DISPLAY , MIE.ROWID FROM MFG_LOOKUPS ML, MFG_LOOKUPS ML1, MFG_LOOKUPS ML2, MTL_PARAMETERS MTP, 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 = -1 AND MTP.ORGANIZATION_ID = MIE.ORGANIZATION_ID AND DEPT.DEPARTMENT_ID = MIE.DEPARTMENT_ID AND RES.RESOURCE_ID = MIE.RESOURCE_ID AND MIE.RESOURCE_ID <> -1 AND LINE.LINE_ID(+)=MIE.LINE_ID AND MIE.DISPLAY=1

View Text - HTML Formatted

SELECT MIE.EXCEPTION_TYPE
, ML1.MEANING
, MIE.COMPILE_DESIGNATOR
, MIE.ORGANIZATION_ID
, MIE.PROJECT_ID
, MIE.TASK_ID
, MIE.VERSION
, NVL(TO_CHAR(MIE.VERSION)
, ML.MEANING)
, MIE.EXCEPTION_COUNT
, MIE.INVENTORY_ITEM_ID
, MSI.PLANNER_CODE
, MSI.CATEGORY_ID
, MIE.PLANNING_GROUP
, MIF.ITEM_NUMBER
, MTP.ORGANIZATION_CODE
, MRP_GET_PROJECT.PROJECT(MIE.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MIE.TASK_ID)
, MSI.BUYER_NAME
, MIE.DEPARTMENT_ID
, MIE.RESOURCE_ID
, MIE.LINE_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, LINE.LINE_CODE
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, MIE.DISPLAY
, MIE.ROWID
FROM MFG_LOOKUPS ML
, MFG_LOOKUPS ML1
, MTL_PARAMETERS MTP
, MTL_ITEM_FLEXFIELDS MIF
, MRP_SYSTEM_ITEMS MSI
, 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 MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR
AND MIF.ITEM_ID = MIE.INVENTORY_ITEM_ID
AND MIF.ORGANIZATION_ID = MIE.ORGANIZATION_ID
AND MTP.ORGANIZATION_ID = MIE.ORGANIZATION_ID
AND MIE.RESOURCE_ID = -1
AND LINE.LINE_ID(+)=MIE.LINE_ID
AND MIE.DISPLAY=1 UNION ALL SELECT MIE.EXCEPTION_TYPE
, ML1.MEANING
, MIE.COMPILE_DESIGNATOR
, MIE.ORGANIZATION_ID
, MIE.PROJECT_ID
, MIE.TASK_ID
, MIE.VERSION
, NVL(TO_CHAR(MIE.VERSION)
, ML.MEANING)
, MIE.EXCEPTION_COUNT
, MIE.INVENTORY_ITEM_ID
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, MIE.PLANNING_GROUP
, NULL
, MTP.ORGANIZATION_CODE
, MRP_GET_PROJECT.PROJECT(MIE.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MIE.TASK_ID)
, TO_CHAR(NULL)
, MIE.DEPARTMENT_ID
, MIE.RESOURCE_ID
, MIE.LINE_ID
, DEPT.DEPARTMENT_CODE
, RES.RESOURCE_CODE
, LINE.LINE_CODE
, RES.RESOURCE_TYPE
, ML2.MEANING
, MIE.DISPLAY
, MIE.ROWID
FROM MFG_LOOKUPS ML
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MTL_PARAMETERS MTP
, 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 = -1
AND MTP.ORGANIZATION_ID = MIE.ORGANIZATION_ID
AND DEPT.DEPARTMENT_ID = MIE.DEPARTMENT_ID
AND RES.RESOURCE_ID = MIE.RESOURCE_ID
AND MIE.RESOURCE_ID <> -1
AND LINE.LINE_ID(+)=MIE.LINE_ID
AND MIE.DISPLAY=1