APPS.MSC_ATP_PF dependencies on MSC_SUB_INVENTORIES

Line 2274: FROM MSC_SUB_INVENTORIES S

2270: D.COMPLETED_QUANTITY)
2271: AND DECODE(MSC_ATP_PVT.G_APPS_VER,3,D.COMPLETED_QUANTITY,0) = 0 -- 2300767
2272: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2273: (SELECT S.SUB_INVENTORY_CODE
2274: FROM MSC_SUB_INVENTORIES S
2275: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2276: AND S.PLAN_ID = I.PLAN_ID
2277: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2278: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,

Line 2321: MSC_SUB_INVENTORIES MSI

2317: MSC_SUPPLIES S,
2318: MSC_ATP_RULES R,
2319: MSC_SYSTEM_ITEMS I,
2320: MSC_SYSTEM_ITEMS I0, --Bug 13072988
2321: MSC_SUB_INVENTORIES MSI
2322: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id -- Bug 13072988, aggregate the supply of member-items
2323: AND I0.ORGANIZATION_ID = p_org_id -- as we are aggregating the demands also.
2324: AND I0.SR_INSTANCE_ID = p_instance_id
2325: AND I0.PLAN_ID = p_plan_id

Line 2851: FROM MSC_SUB_INVENTORIES S

2847: D.COMPLETED_QUANTITY)
2848: AND DECODE(MSC_ATP_PVT.G_APPS_VER,3,D.COMPLETED_QUANTITY,0) = 0 -- 2300767
2849: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2850: (SELECT S.SUB_INVENTORY_CODE
2851: FROM MSC_SUB_INVENTORIES S
2852: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2853: AND S.PLAN_ID = I.PLAN_ID
2854: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2855: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,

Line 2956: MSC_SUB_INVENTORIES MSI

2952: MSC_SUPPLIES S,
2953: MSC_ATP_RULES R,
2954: MSC_SYSTEM_ITEMS I,
2955: MSC_SYSTEM_ITEMS I0, --Bug 13072988
2956: MSC_SUB_INVENTORIES MSI
2957: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id -- Bug 13072988, aggregate the supply of member-items
2958: AND I0.ORGANIZATION_ID = p_org_id -- as we are aggregating the demands also.
2959: AND I0.SR_INSTANCE_ID = p_instance_id
2960: AND I0.PLAN_ID = p_plan_id