[Home] [Help]
View: 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
Name |
PLAN_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
SR_INSTANCE_ID |
DEMAND_CLASS |
DEMAND_DATE |
ALLOCATED_QUANTITY |
DEMAND_ID |
ORIGINATION_TYPE |
ORDER_NUMBER |
SALES_ORDER_LINE_ID |