APPS.WIP_COMPONENT dependencies on MTL_SYSTEM_ITEMS

Line 194: FROM MTL_SYSTEM_ITEMS MSI

190: FROM DUAL
191: WHERE
192: (EXISTS
193: (SELECT 1
194: FROM MTL_SYSTEM_ITEMS MSI
195: WHERE MSI.INVENTORY_ITEM_ID = p_item_id
196: AND MSI.ORGANIZATION_ID = p_org_id
197: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1
198: AND MSI.INVENTORY_ASSET_FLAG = 'N')

Line 214: FROM MTL_SYSTEM_ITEMS MSI

210: FROM DUAL
211: WHERE
212: (EXISTS
213: (SELECT 1
214: FROM MTL_SYSTEM_ITEMS MSI
215: WHERE MSI.INVENTORY_ITEM_ID = p_item_id
216: AND MSI.ORGANIZATION_ID = p_org_id
217: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1
218: AND MSI.INVENTORY_ASSET_FLAG = 'Y')

Line 235: MTL_SYSTEM_ITEMS MSI

231: WHERE
232: NOT EXISTS
233: (SELECT 1
234: FROM MTL_SUBINVENTORIES_VAL_V MSVV,
235: MTL_SYSTEM_ITEMS MSI
236: WHERE MSVV.ORGANIZATION_ID = p_org_id
237: AND MSVV.SECONDARY_INVENTORY_NAME = p_subinventory
238: AND MSI.INVENTORY_ITEM_ID = p_item_id
239: AND MSI.ORGANIZATION_ID = p_org_id

Line 244: MTL_SYSTEM_ITEMS MSI

240: AND MSI.INVENTORY_ASSET_FLAG = 'N'
241: UNION
242: SELECT 1
243: FROM MTL_SUB_AST_TRK_VAL_V MSVV,
244: MTL_SYSTEM_ITEMS MSI
245: WHERE MSVV.ORGANIZATION_ID = p_org_id
246: AND MSVV.SECONDARY_INVENTORY_NAME = p_subinventory
247: AND MSI.INVENTORY_ITEM_ID = p_item_id
248: AND MSI.ORGANIZATION_ID = p_org_id