DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on MTL_UNITS_OF_MEASURE

Line 645: from mtl_units_of_measure mum

641: need to get the correct value */
642: begin
643: select mum.uom_code
644: into x_uom_code
645: from mtl_units_of_measure mum
646: where mum.unit_of_measure = x_uom; --bug 5841426
647: exception
648: when others then
649: x_uom_code := null;

Line 1456: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,

1452: , 'RATE' , PL.committed_amount
1453: , NULL),
1454: PL.purchase_basis, --
1455: pl.ip_category_id --
1456: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,
1457: financials_system_parameters fsp --
1458: where po_header_id=p_po_header_id and
1459: mum.unit_of_measure (+) = pl.unit_meas_lookup_code and --
1460: --bug #2716412: made pl/msi join an outer join