APPS.MSC_ATP_DRP dependencies on MSC_SYSTEM_ITEMS

Line 416: FROM MSC_SYSTEM_ITEMS I,

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

Line 443: FROM MSC_SYSTEM_ITEMS I,

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

Line 470: FROM MSC_SYSTEM_ITEMS I,

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

Line 548: FROM MSC_SYSTEM_ITEMS I,

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

Line 573: FROM MSC_SYSTEM_ITEMS I,

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

Line 597: FROM MSC_SYSTEM_ITEMS I,

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