VIEW: APPS.MRP_FLP_END_DEMAND2_V

Source

View Text - Preformatted

SELECT MGR.ROWID , MGR.DEMAND_ID , MGR.INVENTORY_ITEM_ID , MGR.ORGANIZATION_ID , MGR.COMPILE_DESIGNATOR , MGR.USING_ASSEMBLY_DEMAND_DATE , MGR.ASSEMBLY_DEMAND_COMP_DATE , ROUND(MGR.USING_REQUIREMENTS_QUANTITY,2) , MGR.DEMAND_TYPE , MGR.ORIGINATION_TYPE , ML.MEANING , DECODE(MGR.ORIGINATION_TYPE, 2, WE.WIP_ENTITY_NAME, 3, WE.WIP_ENTITY_NAME, 17, WE.WIP_ENTITY_NAME, 18, MIP.PO_NUMBER, 19, MIP.PO_NUMBER, 20, MIP.PO_NUMBER, 23, MIP.PO_NUMBER, 24, MIP.PO_NUMBER, 25, WE.WIP_ENTITY_NAME, 26, WE.WIP_ENTITY_NAME, 6, SUBSTR(MSO.SEGMENT1, 1, 40), '') , MIF.ITEM_NUMBER||'/'||MP.ORGANIZATION_CODE , SUBSTR(MSI.DESCRIPTION,1,20) , MRP_GET_PROJECT.PROJECT(MGR.PROJECT_ID) , MRP_GET_PROJECT.TASK(MGR.TASK_ID) , MGR.END_ITEM_UNIT_NUMBER , MRP_GET_PROJECT.PROJECT(mgr.lending_project_id) , MRP_GET_PROJECT.TASK(mgr.lending_task_id) FROM MFG_LOOKUPS ML, MRP_ITEM_PURCHASE_ORDERS MIP, WIP_ENTITIES WE, MTL_SALES_ORDERS MSO, MRP_SCHEDULE_DATES MSD, MTL_PARAMETERS MP, MTL_ITEM_FLEXFIELDS MIF, MRP_GROSS_REQUIREMENTS MGR, MRP_SYSTEM_ITEMS MSI WHERE ML.LOOKUP_CODE = MGR.ORIGINATION_TYPE AND ML.LOOKUP_TYPE = 'MRP_DEMAND_ORIGINATION' AND MSO.SALES_ORDER_ID(+) = MSD.SOURCE_SALES_ORDER_ID AND MSD.MPS_TRANSACTION_ID(+) = MGR.DISPOSITION_ID AND MSD.SCHEDULE_LEVEL(+) = 2 AND MSD.SUPPLY_DEMAND_TYPE(+) = 1 AND MIP.TRANSACTION_ID(+) = MGR.DISPOSITION_ID AND WE.WIP_ENTITY_ID(+) = MGR.DISPOSITION_ID AND WE.ORGANIZATION_ID(+) = MGR.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MGR.ORGANIZATION_ID AND MIF.INVENTORY_ITEM_ID = MGR.INVENTORY_ITEM_ID AND MIF.ORGANIZATION_ID = MGR.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MIF.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MIF.ORGANIZATION_ID AND MSI.COMPILE_DESIGNATOR = MGR.COMPILE_DESIGNATOR

View Text - HTML Formatted

SELECT MGR.ROWID
, MGR.DEMAND_ID
, MGR.INVENTORY_ITEM_ID
, MGR.ORGANIZATION_ID
, MGR.COMPILE_DESIGNATOR
, MGR.USING_ASSEMBLY_DEMAND_DATE
, MGR.ASSEMBLY_DEMAND_COMP_DATE
, ROUND(MGR.USING_REQUIREMENTS_QUANTITY
, 2)
, MGR.DEMAND_TYPE
, MGR.ORIGINATION_TYPE
, ML.MEANING
, DECODE(MGR.ORIGINATION_TYPE
, 2
, WE.WIP_ENTITY_NAME
, 3
, WE.WIP_ENTITY_NAME
, 17
, WE.WIP_ENTITY_NAME
, 18
, MIP.PO_NUMBER
, 19
, MIP.PO_NUMBER
, 20
, MIP.PO_NUMBER
, 23
, MIP.PO_NUMBER
, 24
, MIP.PO_NUMBER
, 25
, WE.WIP_ENTITY_NAME
, 26
, WE.WIP_ENTITY_NAME
, 6
, SUBSTR(MSO.SEGMENT1
, 1
, 40)
, '')
, MIF.ITEM_NUMBER||'/'||MP.ORGANIZATION_CODE
, SUBSTR(MSI.DESCRIPTION
, 1
, 20)
, MRP_GET_PROJECT.PROJECT(MGR.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MGR.TASK_ID)
, MGR.END_ITEM_UNIT_NUMBER
, MRP_GET_PROJECT.PROJECT(MGR.LENDING_PROJECT_ID)
, MRP_GET_PROJECT.TASK(MGR.LENDING_TASK_ID)
FROM MFG_LOOKUPS ML
, MRP_ITEM_PURCHASE_ORDERS MIP
, WIP_ENTITIES WE
, MTL_SALES_ORDERS MSO
, MRP_SCHEDULE_DATES MSD
, MTL_PARAMETERS MP
, MTL_ITEM_FLEXFIELDS MIF
, MRP_GROSS_REQUIREMENTS MGR
, MRP_SYSTEM_ITEMS MSI
WHERE ML.LOOKUP_CODE = MGR.ORIGINATION_TYPE
AND ML.LOOKUP_TYPE = 'MRP_DEMAND_ORIGINATION'
AND MSO.SALES_ORDER_ID(+) = MSD.SOURCE_SALES_ORDER_ID
AND MSD.MPS_TRANSACTION_ID(+) = MGR.DISPOSITION_ID
AND MSD.SCHEDULE_LEVEL(+) = 2
AND MSD.SUPPLY_DEMAND_TYPE(+) = 1
AND MIP.TRANSACTION_ID(+) = MGR.DISPOSITION_ID
AND WE.WIP_ENTITY_ID(+) = MGR.DISPOSITION_ID
AND WE.ORGANIZATION_ID(+) = MGR.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MGR.ORGANIZATION_ID
AND MIF.INVENTORY_ITEM_ID = MGR.INVENTORY_ITEM_ID
AND MIF.ORGANIZATION_ID = MGR.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MIF.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND MSI.COMPILE_DESIGNATOR = MGR.COMPILE_DESIGNATOR