View: MRP_FLP_END_DEMAND2_V

Product:	MRP - Master Scheduling/MRP
Description:	View of demand information
Implementation/DBA Data:	APPS.MRP_FLP_END_DEMAND2_V

View Text

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(MIF.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
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

Columns