VIEW: APPS.MRP_WORKBENCH_MESSAGES_SC_V

Source

View Text - Preformatted

SELECT ROWID , QUERY_ID , NUMBER1 , NUMBER2 , CHAR1 , NUMBER3 , NUMBER15 , CHAR8 , NUMBER4 , TO_NUMBER(NULL) , TO_CHAR(NULL) , 1 , TO_CHAR(NULL) , TO_NUMBER(NULL) FROM MRP_FORM_QUERY UNION ALL SELECT MIE.ROWID, TO_NUMBER(NULL) , MIE.EXCEPTION_TYPE , 1 , L1.MEANING , TO_NUMBER(NULL) , MSI.ORGANIZATION_ID , MSI.COMPILE_DESIGNATOR , ORGS.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID , KFV.ITEM_NUMBER || ' - '|| PARAM.ORGANIZATION_CODE||' - '||KFV.DESCRIPTION , 3 , MSI.PLANNER_CODE, MIE.DISPLAY FROM MFG_LOOKUPS L1 , MRP_ITEM_EXCEPTIONS MIE , MTL_ITEM_FLEXFIELDS KFV , MTL_PARAMETERS PARAM , MRP_SYSTEM_ITEMS MSI , MRP_PLAN_ORGANIZATIONS_V ORGS WHERE L1.LOOKUP_TYPE = 'MRP_EXCEPTION_TYPE' AND L1.LOOKUP_CODE = MIE.EXCEPTION_TYPE AND KFV.ORGANIZATION_ID = MIE.ORGANIZATION_ID AND KFV.INVENTORY_ITEM_ID = MIE.INVENTORY_ITEM_ID AND MIE.EXCEPTION_TYPE <> 5 AND MIE.DISPLAY = 1 AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND PARAM.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MSI.ORGANIZATION_ID = ORGS.PLANNED_ORGANIZATION AND MSI.COMPILE_DESIGNATOR = ORGS.COMPILE_DESIGNATOR UNION ALL SELECT DISTINCT MSI.ROWID, TO_NUMBER(NULL) , TO_NUMBER(NULL) , 1 , TO_CHAR(NULL) , TO_NUMBER(NULL) , MSI.ORGANIZATION_ID , MSI.COMPILE_DESIGNATOR , ORGS.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID , KFV.ITEM_NUMBER || ' - '|| PARAM.ORGANIZATION_CODE||' - '||KFV.DESCRIPTION , 2 , MSI.PLANNER_CODE , TO_NUMBER(NULL) FROM MTL_ITEM_FLEXFIELDS KFV , MRP_ITEM_EXCEPTIONS MIE , MTL_PARAMETERS PARAM , MRP_SYSTEM_ITEMS MSI , MRP_PLAN_ORGANIZATIONS_V ORGS WHERE KFV.ORGANIZATION_ID = MIE.ORGANIZATION_ID AND KFV.INVENTORY_ITEM_ID = MIE.INVENTORY_ITEM_ID AND MIE.EXCEPTION_TYPE <> 5 AND MIE.DISPLAY = 1 AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND PARAM.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MSI.ORGANIZATION_ID = ORGS.PLANNED_ORGANIZATION AND MSI.COMPILE_DESIGNATOR = ORGS.COMPILE_DESIGNATOR

View Text - HTML Formatted

SELECT ROWID
, QUERY_ID
, NUMBER1
, NUMBER2
, CHAR1
, NUMBER3
, NUMBER15
, CHAR8
, NUMBER4
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, 1
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
FROM MRP_FORM_QUERY UNION ALL SELECT MIE.ROWID
, TO_NUMBER(NULL)
, MIE.EXCEPTION_TYPE
, 1
, L1.MEANING
, TO_NUMBER(NULL)
, MSI.ORGANIZATION_ID
, MSI.COMPILE_DESIGNATOR
, ORGS.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, KFV.ITEM_NUMBER || ' - '|| PARAM.ORGANIZATION_CODE||' - '||KFV.DESCRIPTION
, 3
, MSI.PLANNER_CODE
, MIE.DISPLAY
FROM MFG_LOOKUPS L1
, MRP_ITEM_EXCEPTIONS MIE
, MTL_ITEM_FLEXFIELDS KFV
, MTL_PARAMETERS PARAM
, MRP_SYSTEM_ITEMS MSI
, MRP_PLAN_ORGANIZATIONS_V ORGS
WHERE L1.LOOKUP_TYPE = 'MRP_EXCEPTION_TYPE'
AND L1.LOOKUP_CODE = MIE.EXCEPTION_TYPE
AND KFV.ORGANIZATION_ID = MIE.ORGANIZATION_ID
AND KFV.INVENTORY_ITEM_ID = MIE.INVENTORY_ITEM_ID
AND MIE.EXCEPTION_TYPE <> 5
AND MIE.DISPLAY = 1
AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR
AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND PARAM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = ORGS.PLANNED_ORGANIZATION
AND MSI.COMPILE_DESIGNATOR = ORGS.COMPILE_DESIGNATOR UNION ALL SELECT DISTINCT MSI.ROWID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, 1
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, MSI.ORGANIZATION_ID
, MSI.COMPILE_DESIGNATOR
, ORGS.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, KFV.ITEM_NUMBER || ' - '|| PARAM.ORGANIZATION_CODE||' - '||KFV.DESCRIPTION
, 2
, MSI.PLANNER_CODE
, TO_NUMBER(NULL)
FROM MTL_ITEM_FLEXFIELDS KFV
, MRP_ITEM_EXCEPTIONS MIE
, MTL_PARAMETERS PARAM
, MRP_SYSTEM_ITEMS MSI
, MRP_PLAN_ORGANIZATIONS_V ORGS
WHERE KFV.ORGANIZATION_ID = MIE.ORGANIZATION_ID
AND KFV.INVENTORY_ITEM_ID = MIE.INVENTORY_ITEM_ID
AND MIE.EXCEPTION_TYPE <> 5
AND MIE.DISPLAY = 1
AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIE.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR
AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND PARAM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = ORGS.PLANNED_ORGANIZATION
AND MSI.COMPILE_DESIGNATOR = ORGS.COMPILE_DESIGNATOR