283:
284: begin
285: select mtl.organization_id
286: into x_owning_organization_id
287: from mtl_system_items msi, mtl_parameters mtl,
288: financials_system_parameters fsp
289: where msi.inventory_item_id = x_item_id
290: and msi.organization_id = fsp.inventory_organization_id
291: and msi.organization_id = mtl.master_organization_id
293: exception
294: when no_data_found then
295: select mtl.organization_id
296: into x_owning_organization_id
297: from mtl_system_items msi, mtl_parameters mtl
298: where msi.inventory_item_id = x_item_id
299: and msi.organization_id = mtl.master_organization_id
300: and msi.organization_id = mtl.organization_id;
301: end;
302:
303:
304: /* select mtl.organization_id
305: into x_owning_organization_id
306: from mtl_system_items msi, mtl_parameters mtl
307: where msi.inventory_item_id = x_item_id
308: and msi.organization_id = mtl.master_organization_id
309: and msi.organization_id = mtl.organization_id;
310: */