262:
263:
264: SELECT DISTINCT msi.inventory_item_id
265: INTO x_item_id
266: FROM mtl_system_items msi,
267: cst_cost_group_assignments ccga
268: WHERE msi.organization_id = ccga.organization_id
269: AND ccga.cost_group_id = x_cost_group_id
270: AND msi.inventory_item_id = ( SELECT cpici.inventory_item_id