APPS.MSC_ATP_DRP dependencies on MSC_PLAN_ORGANIZATIONS

Line 416: MSC_PLAN_ORGANIZATIONS PO,

412: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) SD_DATE,
413: --plan by request date, promise date or schedule date -- 2859130
414: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
415: FROM MSC_SYSTEM_ITEMS I,
416: MSC_PLAN_ORGANIZATIONS PO,
417: MSC_DEMANDS D
418: WHERE PO.plan_id = p_plan_id
419: AND I.PLAN_ID = PO.PLAN_ID
420: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 443: MSC_PLAN_ORGANIZATIONS PO,

439: '@@@' demand_class,
440: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
441: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
442: FROM MSC_SYSTEM_ITEMS I,
443: MSC_PLAN_ORGANIZATIONS PO,
444: MSC_SUPPLIES S
445: WHERE PO.plan_id = p_plan_id
446: AND I.PLAN_ID = PO.PLAN_ID
447: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 470: MSC_PLAN_ORGANIZATIONS PO,

466: -- Bug 4042808 Outbound Shipments are demands. Firm Supply Date
467: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
468: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
469: FROM MSC_SYSTEM_ITEMS I,
470: MSC_PLAN_ORGANIZATIONS PO,
471: MSC_SUPPLIES S
472: WHERE PO.plan_id = p_plan_id
473: AND I.PLAN_ID = PO.PLAN_ID
474: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 548: MSC_PLAN_ORGANIZATIONS PO,

544: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies
545: 0, D.OLD_DEMAND_QUANTITY, -- For summary enhancement
546: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
547: FROM MSC_SYSTEM_ITEMS I,
548: MSC_PLAN_ORGANIZATIONS PO,
549: MSC_DEMANDS D
550: WHERE PO.plan_id = p_plan_id
551: AND I.PLAN_ID = PO.PLAN_ID
552: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 573: MSC_PLAN_ORGANIZATIONS PO,

569: I.inventory_item_id,
570: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
571: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
572: FROM MSC_SYSTEM_ITEMS I,
573: MSC_PLAN_ORGANIZATIONS PO,
574: MSC_SUPPLIES S
575: WHERE PO.plan_id = p_plan_id
576: AND I.PLAN_ID = PO.PLAN_ID
577: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 597: MSC_PLAN_ORGANIZATIONS PO,

593: -- Bug 4042808 Outbound Shipments are demands. Firm Supply Date
594: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
595: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
596: FROM MSC_SYSTEM_ITEMS I,
597: MSC_PLAN_ORGANIZATIONS PO,
598: MSC_SUPPLIES S
599: WHERE PO.plan_id = p_plan_id
600: AND I.PLAN_ID = PO.PLAN_ID
601: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID