APPS.GMF_GET_TRANSFER_PRICE_PUB dependencies on QP_LIST_HEADERS

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

Line 1005: FROM QP_LIST_HEADERS

1001: AND inventory_item_id = g_inventory_item_id;
1002:
1003: SELECT name
1004: INTO l_pricelist_name
1005: FROM QP_LIST_HEADERS
1006: WHERE list_header_id = l_pricelist_id;
1007:
1008: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
1009: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);