DBA Data[Home] [Help]

APPS.PO_REQIMP_S dependencies on PO_UOM_S

Line 124: --SELECT round(po_uom_s.po_uom_convert(msi.primary_unit_of_measure, x_uom, x_item_id),10)

120: --Bug# 1347733
121: --togeorge 12/05/2000
122: --Switched the first two arguments in the call to the procedure po_uom_convert.
123: --This is done to avoid inaccurate value after conversion.
124: --SELECT round(po_uom_s.po_uom_convert(msi.primary_unit_of_measure, x_uom, x_item_id),10)
125: SELECT round(po_uom_s.po_uom_convert(x_uom, msi.primary_unit_of_measure, x_item_id),10)
126: INTO x_uom_conversion_temp
127: FROM mtl_system_items msi
128: WHERE msi.inventory_item_id = x_item_id

Line 125: SELECT round(po_uom_s.po_uom_convert(x_uom, msi.primary_unit_of_measure, x_item_id),10)

121: --togeorge 12/05/2000
122: --Switched the first two arguments in the call to the procedure po_uom_convert.
123: --This is done to avoid inaccurate value after conversion.
124: --SELECT round(po_uom_s.po_uom_convert(msi.primary_unit_of_measure, x_uom, x_item_id),10)
125: SELECT round(po_uom_s.po_uom_convert(x_uom, msi.primary_unit_of_measure, x_item_id),10)
126: INTO x_uom_conversion_temp
127: FROM mtl_system_items msi
128: WHERE msi.inventory_item_id = x_item_id
129: AND x_inventory_org_id = msi.organization_id