APPS.GMF_GET_TRANSFER_PRICE_PUB dependencies on QP_LIST_LINES

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

905: l_transfer_price_code := G_XFER_PRICE_IN_TXN_UOM; -- (1)
906:
907: SELECT spll.operand, substr(spl.currency_code, 1, 15)
908: INTO l_transfer_price, l_pricelist_currency
909: FROM qp_list_headers_b spl, qp_list_lines spll, qp_pricing_attributes qpa
910: WHERE spl.list_header_id = l_pricelist_id
911: AND spll.list_header_id = spl.list_header_id
912: AND spll.list_line_id = qpa.list_line_id
913: AND qpa.product_attribute_context = 'ITEM'

Line 937: FROM qp_list_headers_b spl, qp_list_lines spll,

933: l_transfer_price_code := G_XFER_PRICE_IN_PRI_UOM; -- (2)
934:
935: SELECT spll.operand, substr(spl.currency_code, 1, 15), msi.primary_uom_code
936: INTO l_transfer_price, l_pricelist_currency, l_primary_uom
937: FROM qp_list_headers_b spl, qp_list_lines spll,
938: qp_pricing_attributes qpa, mtl_system_items_b msi
939: WHERE msi.organization_id = g_from_organization_id
940: AND msi.inventory_item_id = g_inventory_item_id
941: AND spl.list_header_id = l_pricelist_id