APPS.MRP_ATP_COLLECTION dependencies on MTL_SECONDARY_INVENTORIES

Line 95: FROM MTL_SECONDARY_INVENTORIES S,

91: FROM (
92: SELECT I.INVENTORY_ITEM_ID item_id,
93: I.ORGANIZATION_ID org_id,
94: Q.TRANSACTION_QUANTITY transaction_qty
95: FROM MTL_SECONDARY_INVENTORIES S,
96: MTL_PARAMETERS P ,
97: MTL_ONHAND_QUANTITIES Q ,
98: MTL_ATP_RULES R ,
99: MTL_SYSTEM_ITEMS I

Line 114: FROM MTL_SECONDARY_INVENTORIES S,

110: UNION ALL
111: SELECT I.INVENTORY_ITEM_ID item_id,
112: I.ORGANIZATION_ID org_id,
113: T.PRIMARY_QUANTITY transaction_qty
114: FROM MTL_SECONDARY_INVENTORIES S,
115: MTL_PARAMETERS P ,
116: MTL_MATERIAL_TRANSACTIONS_TEMP T ,
117: MTL_ATP_RULES R ,
118: MTL_SYSTEM_ITEMS I

Line 342: FROM MTL_SECONDARY_INVENTORIES S2

338: AND S.ITEM_ID = I.INVENTORY_ITEM_ID
339: AND S.DESTINATION_TYPE_CODE='INVENTORY'
340: AND (S.TO_SUBINVENTORY IS NULL OR
341: EXISTS (SELECT 'X'
342: FROM MTL_SECONDARY_INVENTORIES S2
343: WHERE S2.ORGANIZATION_ID=S.TO_ORGANIZATION_ID
344: AND S2.SECONDARY_INVENTORY_NAME = S.TO_SUBINVENTORY
345: AND S2.INVENTORY_ATP_CODE = 1))
346: AND C.CALENDAR_CODE = P.CALENDAR_CODE

Line 969: FROM MTL_SECONDARY_INVENTORIES S

965: AND D.DEMAND_SOURCE_TYPE <> DECODE(R.INCLUDE_INTERNAL_ORDERS,2,8,-1)
966: AND D.AVAILABLE_TO_ATP = 1
967: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
968: (SELECT S.SECONDARY_INVENTORY_NAME
969: FROM MTL_SECONDARY_INVENTORIES S
970: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
971: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,
972: 1, 1, NULL, 1, S.INVENTORY_ATP_CODE)
973: AND S.AVAILABILITY_TYPE =DECODE(R.DEFAULT_ATP_SOURCES,