DBA Data[Home] [Help]

APPS.PO_ASL_UPGRADE_SV2 dependencies on MTL_PARAMETERS

Line 287: from mtl_system_items msi, mtl_parameters mtl,

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

Line 297: from mtl_system_items msi, mtl_parameters mtl

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;

Line 306: from mtl_system_items msi, mtl_parameters mtl

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: */