APPS.INVIDSCS dependencies on MTL_SYSTEM_ITEMS

Line 187: from MTL_SYSTEM_ITEMS MSI

183: into inv_item_flag, purch_item_flag,
184: int_order_flag, serv_item_flag,
185: cost_enab_flag, engg_item_flag, cust_order_flag,
186: mrp_plan_code, eam_item_type, contract_item_type --Bug: 2527058
187: from MTL_SYSTEM_ITEMS MSI
188: where MSI.inventory_item_id = current_item_id
189: and MSI.organization_id = current_org_id;
190:
191: END GET_ITEM_DEFINING_FLAGS;

Line 219: from mtl_system_items i

215: where p.master_organization_id = current_master_org_id
216: and p.organization_id <> current_master_org_id
217: and exists
218: (select 'x'
219: from mtl_system_items i
220: where i.inventory_item_id = current_inv_item_id
221: and i.organization_id = p.organization_id)
222: /* Bug: 4932378 and exists
223: (select 'x'

Line 313: and exists (select 'x' from mtl_system_items i

309: and c.organization_id in
310: (select p.organization_id from mtl_parameters p
311: where p.master_organization_id =
312: current_master_org_id
313: and exists (select 'x' from mtl_system_items i
314: where i.inventory_item_id =
315: current_inv_item_id
316: and i.organization_id = p.organization_id)
317: /* Bug: 4932378

Line 362: from mtl_system_items

358: )
359: IS
360: CURSOR other_orgs_cur IS
361: select organization_id
362: from mtl_system_items
363: where
364: inventory_item_id = current_inv_item_id and
365: organization_id <> current_org_id and
366: organization_id in