DBA Data[Home] [Help]

APPS.PO_REQIMP_S dependencies on PO_LINE_TYPES

Line 141: po_line_types plt

137: --This is done to avoid inaccurate value after conversion.
138: --SET pri.unit_price = (SELECT round(msi.list_price_per_unit / (x_uom_conversion_temp),10)
139: SET pri.unit_price = (SELECT round(msi.list_price_per_unit * (x_uom_conversion_temp),10)
140: FROM mtl_system_items msi,
141: po_line_types plt
142: WHERE msi.inventory_item_id = pri.item_id
143: AND x_inventory_org_id
144: = msi.organization_id
145: AND pri.line_type_id = plt.line_type_id