APPS.PO_REQIMP_S dependencies on PO_LINE_TYPES

Line 142: po_line_types plt

138: BEGIN
139: SELECT round(msi.list_price_per_unit * (x_uom_conversion_temp),10)
140: INTO x_list_price
141: FROM mtl_system_items msi,
142: po_line_types plt
143: WHERE msi.inventory_item_id = x_item_id
144: AND msi.organization_id = x_destination_org_id
145: AND plt.line_type_id = x_line_type_id
146: AND plt.order_type_lookup_code = 'QUANTITY';

Line 157: po_line_types plt

153: BEGIN
154: SELECT round(msi.list_price_per_unit * (x_uom_conversion_temp),10)
155: INTO x_list_price
156: FROM mtl_system_items msi,
157: po_line_types plt
158: WHERE msi.inventory_item_id = x_item_id
159: AND msi.organization_id = x_inventory_org_id
160: AND plt.line_type_id = x_line_type_id
161: AND plt.order_type_lookup_code = 'QUANTITY';

Line 177: po_line_types plt

173: --SET pri.unit_price = (SELECT round(msi.list_price_per_unit / (x_uom_conversion_temp),10)
174: --Commented below to update price with x_list_price Bug# 11668528
175: /* SET pri.unit_price = (SELECT round(msi.list_price_per_unit * (x_uom_conversion_temp),10)
176: FROM mtl_system_items msi,
177: po_line_types plt
178: WHERE msi.inventory_item_id = pri.item_id
179: AND pri.DESTINATION_ORGANIZATION_ID
180: = msi.organization_id
181: AND pri.line_type_id = plt.line_type_id