eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_DRP dependencies on MSC_SYSTEM_ITEMS

Line 415: FROM MSC_SYSTEM_ITEMS I,

411: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
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

Line 442: FROM MSC_SYSTEM_ITEMS I,

438: I.inventory_item_id,
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

Line 469: FROM MSC_SYSTEM_ITEMS I,

465: TRUNC(NVL(S.NEW_SHIP_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
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

Line 547: FROM MSC_SYSTEM_ITEMS I,

543: --plan by request date, promise date or schedule date
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

Line 572: FROM MSC_SYSTEM_ITEMS I,

568: I.organization_id,
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

Line 596: FROM MSC_SYSTEM_ITEMS I,

592: TRUNC(NVL(S.NEW_SHIP_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
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