DBA Data[Home] [Help]

APPS.PO_REQIMP_S dependencies on PO_UOM_S

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

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

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

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