324: SELECT organization_id
325: FROM gmi_item_organizations
326: UNION
327: SELECT distinct p.master_organization_id 328: FROM mtl_parameters p, 329: gmi_item_organizations g
330: WHERE p.organization_id = g.organization_id;
331:
332: CURSOR get_inventory_item_id(C_item_no VARCHAR2) IS