APPS.MSC_ATP_REQ dependencies on MSC_SUB_INVENTORIES

Line 2123: FROM MSC_SUB_INVENTORIES S

2119: D.COMPLETED_QUANTITY)
2120: AND DECODE(MSC_ATP_PVT.G_APPS_VER,3,D.COMPLETED_QUANTITY,0) = 0 -- 2300767
2121: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2122: (SELECT S.SUB_INVENTORY_CODE
2123: FROM MSC_SUB_INVENTORIES S
2124: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2125: AND S.PLAN_ID = I.PLAN_ID
2126: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2127: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,

Line 2160: MSC_SUB_INVENTORIES MSI

2156: FROM MSC_CALENDAR_DATES C,
2157: MSC_SUPPLIES S,
2158: MSC_ATP_RULES R,
2159: MSC_SYSTEM_ITEMS I,
2160: MSC_SUB_INVENTORIES MSI
2161: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2162: AND I.ORGANIZATION_ID = p_org_id
2163: AND I.SR_INSTANCE_ID = p_instance_id
2164: AND I.PLAN_ID = p_plan_id

Line 2669: FROM MSC_SUB_INVENTORIES S

2665: D.COMPLETED_QUANTITY)
2666: AND DECODE(MSC_ATP_PVT.G_APPS_VER,3,D.COMPLETED_QUANTITY,0) = 0 -- 2300767
2667: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2668: (SELECT S.SUB_INVENTORY_CODE
2669: FROM MSC_SUB_INVENTORIES S
2670: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2671: AND S.PLAN_ID = I.PLAN_ID
2672: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2673: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,

Line 2764: MSC_SUB_INVENTORIES MSI

2760: FROM MSC_CALENDAR_DATES C,
2761: MSC_SUPPLIES S,
2762: MSC_ATP_RULES R,
2763: MSC_SYSTEM_ITEMS I,
2764: MSC_SUB_INVENTORIES MSI
2765: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2766: AND I.ORGANIZATION_ID = p_org_id
2767: AND I.SR_INSTANCE_ID = p_instance_id
2768: AND I.PLAN_ID = p_plan_id