VIEW: APPS.MRP_FLP_SUPPLY_V

Source

View Text - Preformatted

SELECT MR.TRANSACTION_ID , MR.INVENTORY_ITEM_ID , MR.ORGANIZATION_ID , MR.COMPILE_DESIGNATOR , MR.NEW_SCHEDULE_DATE , MR.NEW_ORDER_QUANTITY , MR.ORDER_TYPE , MR.NEW_PROCESSING_DAYS , ML.MEANING , DECODE(MR.ORDER_TYPE, 1, MIP.PO_NUMBER, 2, MIP.PO_NUMBER, 3, WE.WIP_ENTITY_NAME, 7, WE.WIP_ENTITY_NAME, 14, WE.WIP_ENTITY_NAME, 15, WE.WIP_ENTITY_NAME, 11, MIP.PO_NUMBER, 12, MIP.PO_NUMBER, 8, MIP.PO_NUMBER, 27, WE.WIP_ENTITY_NAME, 28, WE.WIP_ENTITY_NAME, '') , MRP_GET_PROJECT.PROJECT(MR.PROJECT_ID) , MRP_GET_PROJECT.TASK(MR.TASK_ID) , MIF.ITEM_NUMBER||'/'||MP.ORGANIZATION_CODE , SUBSTR(MSI.DESCRIPTION,1,20) , MR.END_ITEM_UNIT_NUMBER FROM MFG_LOOKUPS ML, MRP_ITEM_PURCHASE_ORDERS MIP, WIP_ENTITIES WE, MTL_PARAMETERS MP, MTL_ITEM_FLEXFIELDS MIF, MRP_RECOMMENDATIONS MR, MRP_SYSTEM_ITEMS MSI WHERE MIF.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID AND MIF.ORGANIZATION_ID = MR.ORGANIZATION_ID AND WE.WIP_ENTITY_ID(+) = MR.DISPOSITION_ID AND WE.ORGANIZATION_ID(+) = MR.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MR.ORGANIZATION_ID AND MIP.TRANSACTION_ID(+) = MR.DISPOSITION_ID AND ML.LOOKUP_TYPE = 'MRP_ORDER_TYPE' AND MR.ORDER_TYPE = ML.LOOKUP_CODE AND MSI.INVENTORY_ITEM_ID = MIF.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MIF.ORGANIZATION_ID AND MSI.COMPILE_DESIGNATOR = MR.COMPILE_DESIGNATOR

View Text - HTML Formatted

SELECT MR.TRANSACTION_ID
, MR.INVENTORY_ITEM_ID
, MR.ORGANIZATION_ID
, MR.COMPILE_DESIGNATOR
, MR.NEW_SCHEDULE_DATE
, MR.NEW_ORDER_QUANTITY
, MR.ORDER_TYPE
, MR.NEW_PROCESSING_DAYS
, ML.MEANING
, DECODE(MR.ORDER_TYPE
, 1
, MIP.PO_NUMBER
, 2
, MIP.PO_NUMBER
, 3
, WE.WIP_ENTITY_NAME
, 7
, WE.WIP_ENTITY_NAME
, 14
, WE.WIP_ENTITY_NAME
, 15
, WE.WIP_ENTITY_NAME
, 11
, MIP.PO_NUMBER
, 12
, MIP.PO_NUMBER
, 8
, MIP.PO_NUMBER
, 27
, WE.WIP_ENTITY_NAME
, 28
, WE.WIP_ENTITY_NAME
, '')
, MRP_GET_PROJECT.PROJECT(MR.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MR.TASK_ID)
, MIF.ITEM_NUMBER||'/'||MP.ORGANIZATION_CODE
, SUBSTR(MSI.DESCRIPTION
, 1
, 20)
, MR.END_ITEM_UNIT_NUMBER
FROM MFG_LOOKUPS ML
, MRP_ITEM_PURCHASE_ORDERS MIP
, WIP_ENTITIES WE
, MTL_PARAMETERS MP
, MTL_ITEM_FLEXFIELDS MIF
, MRP_RECOMMENDATIONS MR
, MRP_SYSTEM_ITEMS MSI
WHERE MIF.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID
AND MIF.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID(+) = MR.DISPOSITION_ID
AND WE.ORGANIZATION_ID(+) = MR.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND MIP.TRANSACTION_ID(+) = MR.DISPOSITION_ID
AND ML.LOOKUP_TYPE = 'MRP_ORDER_TYPE'
AND MR.ORDER_TYPE = ML.LOOKUP_CODE
AND MSI.INVENTORY_ITEM_ID = MIF.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND MSI.COMPILE_DESIGNATOR = MR.COMPILE_DESIGNATOR