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_PF dependencies on MSC_SUB_INVENTORIES

Line 2267: FROM MSC_SUB_INVENTORIES S

2263: D.COMPLETED_QUANTITY)
2264: AND DECODE(MSC_ATP_PVT.G_APPS_VER,3,D.COMPLETED_QUANTITY,0) = 0 -- 2300767
2265: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2266: (SELECT S.SUB_INVENTORY_CODE
2267: FROM MSC_SUB_INVENTORIES S
2268: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2269: AND S.PLAN_ID = I.PLAN_ID
2270: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2271: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,

Line 2313: MSC_SUB_INVENTORIES MSI

2309: FROM MSC_CALENDAR_DATES C,
2310: MSC_SUPPLIES S,
2311: MSC_ATP_RULES R,
2312: MSC_SYSTEM_ITEMS I,
2313: MSC_SUB_INVENTORIES MSI
2314: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2315: AND I.ORGANIZATION_ID = p_org_id
2316: AND I.SR_INSTANCE_ID = p_instance_id
2317: AND I.PLAN_ID = p_plan_id

Line 2839: FROM MSC_SUB_INVENTORIES S

2835: D.COMPLETED_QUANTITY)
2836: AND DECODE(MSC_ATP_PVT.G_APPS_VER,3,D.COMPLETED_QUANTITY,0) = 0 -- 2300767
2837: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2838: (SELECT S.SUB_INVENTORY_CODE
2839: FROM MSC_SUB_INVENTORIES S
2840: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2841: AND S.PLAN_ID = I.PLAN_ID
2842: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2843: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,

Line 2943: MSC_SUB_INVENTORIES MSI

2939: FROM MSC_CALENDAR_DATES C,
2940: MSC_SUPPLIES S,
2941: MSC_ATP_RULES R,
2942: MSC_SYSTEM_ITEMS I,
2943: MSC_SUB_INVENTORIES MSI
2944: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2945: AND I.ORGANIZATION_ID = p_org_id
2946: AND I.SR_INSTANCE_ID = p_instance_id
2947: AND I.PLAN_ID = p_plan_id