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_PLAN_ORGANIZATIONS

Line 417: MSC_PLAN_ORGANIZATIONS PO,

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
421: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 444: MSC_PLAN_ORGANIZATIONS PO,

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
448: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 471: MSC_PLAN_ORGANIZATIONS PO,

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
475: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 549: MSC_PLAN_ORGANIZATIONS PO,

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
553: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 574: MSC_PLAN_ORGANIZATIONS PO,

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
578: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID

Line 598: MSC_PLAN_ORGANIZATIONS PO,

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
602: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID