View: MRP_FLP_END_DEMAND_V

Product:	MRP - Master Scheduling/MRP
Description:	View of demand information for end assemblies
Implementation/DBA Data:	APPS.MRP_FLP_END_DEMAND_V

View Text

SELECT MFP.ROWID
, MFP.ORGANIZATION_ID
, MFP.COMPILE_DESIGNATOR
, MFP.PEGGING_ID
, MFP.TRANSACTION_ID
, MFP.DEMAND_ID
, NVL(MFP.PREV_PEGGING_ID
, -1)
, MFP.INVENTORY_ITEM_ID
, DECODE(MFP.DEMAND_ID
, -1
, ROUND(MFP.ALLOCATED_QUANTITY
, 2)
, ROUND(MFP.DEMAND_QUANTITY
, 2))
, ROUND(MR.NEW_ORDER_QUANTITY
, 2)
, ROUND(MFP.ALLOCATED_QUANTITY
, 2)
, DECODE(MFP.DEMAND_ID
, -1
, MFP.SUPPLY_DATE
, MFP.DEMAND_DATE)
, DECODE(MFP.DEMAND_ID
, -1
, DECODE(ML2.MEANING
, NULL
, ML.MEANING
, ML.MEANING||'/'||ML2.MEANING)
, 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)
, DECODE(MFP.DEMAND_ID
, -1
, MRP_GET_PROJECT.PROJECT(MFP.PROJECT_ID)
, -3
, MRP_GET_PROJECT.PROJECT(MFP.PROJECT_ID)
, MRP_GET_PROJECT.PROJECT(MGR.PROJECT_ID))
, DECODE(MFP.DEMAND_ID
, -1
, MRP_GET_PROJECT.TASK(MFP.TASK_ID)
, -3
, MRP_GET_PROJECT.TASK(MFP.TASK_ID)
, MRP_GET_PROJECT.TASK(MGR.TASK_ID))
, SL.DEMAND_CLASS_CODE
, SL.ATTRIBUTE1
, SL.ATTRIBUTE2
, SL.ATTRIBUTE3
, SL.ATTRIBUTE4
, SL.ATTRIBUTE5
, SL.ATTRIBUTE6
, SL.ATTRIBUTE7
, SL.ATTRIBUTE8
, SL.ATTRIBUTE9
, SL.ATTRIBUTE10
, SL.ATTRIBUTE11
, SL.ATTRIBUTE12
, SL.ATTRIBUTE13
, SL.ATTRIBUTE14
, SL.ATTRIBUTE15
, 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
, MFG_LOOKUPS ML2
, MRP_ITEM_PURCHASE_ORDERS MIP
, WIP_ENTITIES WE
, MTL_SALES_ORDERS MSO
, MRP_SCHEDULE_DATES MSD
, MTL_ITEM_FLEXFIELDS MIF
, MTL_PARAMETERS MP
, OE_ORDER_LINES_ALL SL
, MTL_DEMAND_OMOE MD
, MRP_RECOMMENDATIONS MR
, MRP_GROSS_REQUIREMENTS MGR
, MRP_FULL_PEGGING MFP
WHERE ML.LOOKUP_CODE = DECODE(MFP.DEMAND_ID
, -1
, MFP.DEMAND_ID
, -2
, MFP.DEMAND_ID
, -3
, MFP.DEMAND_ID
, MGR.ORIGINATION_TYPE)
AND ML.LOOKUP_TYPE = DECODE(MFP.DEMAND_ID
, -1
, 'TEST_FLP_SUPPLY_DEMAND_TYPE'
, -2
, 'TEST_FLP_SUPPLY_DEMAND_TYPE'
, -3
, 'TEST_FLP_SUPPLY_DEMAND_TYPE'
, 'MRP_DEMAND_ORIGINATION')
AND ML2.LOOKUP_CODE(+)=DECODE(MFP.SUPPLY_TYPE
, 10
, 5
, 13
, 5
, MFP.SUPPLY_TYPE)
AND ML2.LOOKUP_TYPE(+)=DECODE(MFP.SUPPLY_TYPE
, 18
, 'TEST_FLP_SUPPLY_DEMAND_TYPE'
, 'MRP_ORDER_TYPE')
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 SL.LINE_ID(+) = MD.DEMAND_SOURCE_LINE
AND MD.DEMAND_ID(+) = MGR.RESERVATION_ID
AND MGR.DEMAND_ID(+) = MFP.DEMAND_ID
AND MR.TRANSACTION_ID(+) = MFP.TRANSACTION_ID
AND MP.ORGANIZATION_ID = MFP.ORGANIZATION_ID
AND MIF.INVENTORY_ITEM_ID = MFP.INVENTORY_ITEM_ID
AND MIF.ORGANIZATION_ID = MFP.ORGANIZATION_ID
AND MFP.PREV_PEGGING_ID IS NULL

Columns