VIEW: APPS.MSC_DEMAND_PEGGING_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)