APPS.GMF_GET_TRANSFER_PRICE_PUB dependencies on QP_LIST_LINES

Line 825: FROM qp_list_headers_b spl, qp_list_lines spll, qp_pricing_attributes qpa

821: l_transfer_price_code := G_XFER_PRICE_IN_TXN_UOM; -- (1)
822:
823: SELECT spll.operand, substr(spl.currency_code, 1, 15)
824: INTO l_transfer_price, l_pricelist_currency
825: FROM qp_list_headers_b spl, qp_list_lines spll, qp_pricing_attributes qpa
826: WHERE spl.list_header_id = l_pricelist_id
827: AND spll.list_header_id = spl.list_header_id
828: AND spll.list_line_id = qpa.list_line_id
829: AND qpa.product_attribute_context = 'ITEM'

Line 853: FROM qp_list_headers_b spl, qp_list_lines spll,

849: l_transfer_price_code := G_XFER_PRICE_IN_PRI_UOM; -- (2)
850:
851: SELECT spll.operand, substr(spl.currency_code, 1, 15), msi.primary_uom_code
852: INTO l_transfer_price, l_pricelist_currency, l_primary_uom
853: FROM qp_list_headers_b spl, qp_list_lines spll,
854: qp_pricing_attributes qpa, mtl_system_items_b msi
855: WHERE msi.organization_id = g_from_organization_id
856: AND msi.inventory_item_id = g_inventory_item_id
857: AND spl.list_header_id = l_pricelist_id