DBA Data[Home] [Help]

APPS.PO_ASL_UPGRADE_SV dependencies on MTL_SYSTEM_ITEMS

Line 391: from mtl_system_items msi, mtl_parameters mtl,

387: */
388: begin
389: select mtl.organization_id
390: into x_organization_id
391: from mtl_system_items msi, mtl_parameters mtl,
392: financials_system_parameters fsp --1776173
393: where msi.inventory_item_id = x_item_id
394: and msi.organization_id = fsp.inventory_organization_id --1776173
395: and msi.organization_id = mtl.master_organization_id

Line 401: from mtl_system_items msi, mtl_parameters mtl

397: exception
398: when no_data_found then
399: select mtl.organization_id
400: into x_organization_id
401: from mtl_system_items msi, mtl_parameters mtl
402: where msi.inventory_item_id = x_item_id
403: and msi.organization_id = mtl.master_organization_id
404: and msi.organization_id = mtl.organization_id;
405: fnd_file.put_line(fnd_file.log, 'In the exception');