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 312: and exists (select 'x' from mtl_system_items i

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

Line 361: from mtl_system_items

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