[Home] [Help]
View: MSC_SUPPLY_PEGGING_V
View Text
SELECT PEG2.PLAN_ID
, PEG2.INVENTORY_ITEM_ID
, PEG2.ORGANIZATION_ID
, PEG2.SR_INSTANCE_ID
, NVL(D.DEMAND_CLASS
, '-1') DEMAND_CLASS
, S.NEW_SCHEDULE_DATE SUPPLY_DATE
, PEG2.ALLOCATED_QUANTITY
, PEG2.TRANSACTION_ID
, S.ORDER_TYPE
, S.ORDER_NUMBER
, S.SCHEDULE_DESIGNATOR_ID
FROM MSC_DEMANDS D
, MSC_SUPPLIES S
, MSC_FULL_PEGGING PEG2
, MSC_FULL_PEGGING PEG1
WHERE PEG2.PLAN_ID = PEG1.PLAN_ID
AND PEG2.END_PEGGING_ID = PEG1.PEGGING_ID
AND D.PLAN_ID = PEG1.PLAN_ID
AND D.DEMAND_ID = PEG1.DEMAND_ID
AND D.SR_INSTANCE_ID = PEG1.SR_INSTANCE_ID AND D.INVENTORY_ITEM_ID = PEG1.INVENTORY_ITEM_ID
AND S.PLAN_ID = PEG2.PLAN_ID
AND S.TRANSACTION_ID = PEG2.TRANSACTION_ID
AND S.SR_INSTANCE_ID = PEG2.SR_INSTANCE_ID
Columns
Name |
PLAN_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
SR_INSTANCE_ID |
DEMAND_CLASS |
SUPPLY_DATE |
ALLOCATED_QUANTITY |
TRANSACTION_ID |
ORDER_TYPE |
ORDER_NUMBER |
SCHEDULE_DESIGNATOR_ID |