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 747: MSC_PLANS P -- For summary enhancement

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

Line 769: MSC_PLANS P -- For summary enhancement

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

Line 788: MSC_PLANS P -- For summary enhancement

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