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_PLANS

Line 746: MSC_PLANS P -- For summary enhancement

742: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies
743: 0, nvl(D.OLD_DEMAND_QUANTITY,0), --4658238 -- For summary enhancement
744: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
745: FROM MSC_DEMANDS D,
746: MSC_PLANS P -- For summary enhancement
747: WHERE D.PLAN_ID = p_plan_id
748: AND D.SR_INSTANCE_ID = p_instance_id
749: AND D.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
750: AND D.ORGANIZATION_ID = p_org_id

Line 768: MSC_PLANS P -- For summary enhancement

764:
765: SELECT TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
766: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
767: FROM MSC_SUPPLIES S,
768: MSC_PLANS P -- For summary enhancement
769: WHERE S.PLAN_ID = p_plan_id
770: AND S.SR_INSTANCE_ID = p_instance_id
771: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
772: AND S.ORGANIZATION_ID = p_org_id

Line 787: MSC_PLANS P -- For summary enhancement

783: -- Bug 4042808 Outbound Shipments are demands. Firm Supply Date
784: -- does not apply. (Previous Comment -- Firm Date is common across orgs).
785: -1 * NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
786: FROM MSC_SUPPLIES S,
787: MSC_PLANS P -- For summary enhancement
788: WHERE S.PLAN_ID = p_plan_id
789: AND S.SOURCE_SR_INSTANCE_ID = p_instance_id
790: AND S.SOURCE_ORGANIZATION_ID = p_org_id
791: AND S.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id