APPS.GMF_GET_TRANSFER_PRICE_PUB dependencies on QP_LIST_HEADERS

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

Line 921: FROM QP_LIST_HEADERS

917: AND inventory_item_id = g_inventory_item_id;
918:
919: SELECT name
920: INTO l_pricelist_name
921: FROM QP_LIST_HEADERS
922: WHERE list_header_id = l_pricelist_id;
923:
924: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
925: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);