DBA Data[Home] [Help]

APPS.PO_ASL_UPGRADE_SV dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 385: added the join to financials system parameters which will ensure

381: /*Bug 1776173
382: If one item is assigned to multiple inventory organizations and
383: each of those of have different master organizations then
384: to prevent the following sql from returning too many rows
385: added the join to financials system parameters which will ensure
386: that only row is returned.
387: */
388: begin
389: select mtl.organization_id

Line 392: financials_system_parameters fsp --1776173

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
396: and msi.organization_id = mtl.organization_id;