View: MSC_DEMAND_PEGGING_V

Product:	MSC - Advanced Supply Chain Planning
Description:	Demand pegging
Implementation/DBA Data:	APPS.MSC_DEMAND_PEGGING_V

View Text

SELECT PEG2.PLAN_ID
, PEG2.INVENTORY_ITEM_ID
, PEG2.ORGANIZATION_ID
, PEG2.SR_INSTANCE_ID
, NVL(D1.DEMAND_CLASS
, '-1') DEMAND_CLASS
, D2.USING_ASSEMBLY_DEMAND_DATE DEMAND_DATE
, PEG2.ALLOCATED_QUANTITY
, D2.DEMAND_ID
, D2.ORIGINATION_TYPE
, D2.ORDER_NUMBER
, D2.SALES_ORDER_LINE_ID
FROM MSC_DEMANDS D1
, MSC_DEMANDS D2
, MSC_FULL_PEGGING PEG2
, MSC_FULL_PEGGING PEG1
WHERE PEG2.PLAN_ID = PEG1.PLAN_ID
AND PEG2.END_PEGGING_ID = PEG1.PEGGING_ID
AND PEG2.SR_INSTANCE_ID = PEG1.SR_INSTANCE_ID
AND D1.PLAN_ID = PEG1.PLAN_ID
AND D1.DEMAND_ID = PEG1.DEMAND_ID
AND D1.SR_INSTANCE_ID = PEG1.SR_INSTANCE_ID
AND D2.PLAN_ID = PEG2.PLAN_ID
AND D2.DEMAND_ID = PEG2.DEMAND_ID
AND D2.SR_INSTANCE_ID = PEG2.SR_INSTANCE_ID
AND D2.ORIGINATION_TYPE NOT IN (5
, 7
, 8
, 9
, 11
, 15
, 22
, 28
, 29
, 31)

Columns