APPS.AS_FOUNDATION_PVT dependencies on QP_PRICE_LISTS_V

Line 958: From qp_price_lists_v pr_head, qp_price_list_lines_v pr_line

954: p_price_list_id Number) IS
955: Select pr_line.list_price,
956: pr_head.currency_code
957: --From oe_price_lists pr_head, oe_price_list_lines pr_line
958: From qp_price_lists_v pr_head, qp_price_list_lines_v pr_line
959: Where pr_head.price_list_id = p_price_list_id
960: And pr_line.inventory_item_id = p_inventory_item_id
961: And pr_line.unit_code = p_unit_code
962: And pr_head.secondary_price_list_id = pr_line.price_list_id

Line 1183: FROM as_price_lists apl, qp_price_lists_v spl

1179: x_price_list_id OUT NOCOPY NUMBER) IS
1180: CURSOR l_price_list_id_csr (c_group_id NUMBER, c_currency_code VARCHAR2) IS
1181: SELECT apl.price_list_id
1182: --FROM as_price_lists apl, oe_price_lists spl
1183: FROM as_price_lists apl, qp_price_lists_v spl
1184: WHERE apl.group_id = c_group_id
1185: AND apl.price_list_id = spl.price_list_id
1186: AND spl.currency_code = c_currency_code;
1187: