APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_LIST_HEADERS_B

Line 2039: qp_list_headers_b qplh

2035: , NULL line_detail_type_code
2036: , line.line_category
2037: , line.price_flag
2038: from qp_npreq_lines_tmp line, oe_price_adjustments adj,
2039: qp_list_headers_b qplh
2040: -- where p_request_type_code = 'ONT'
2041: --bug 3085453 handle pricing availability UI
2042: -- they pass reqtype ONT and insert adj into ldets
2043: where QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 2150: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh

2146: , NULL line_detail_type_code
2147: , line.line_category
2148: , line.price_flag
2149: from qp_npreq_lines_tmp line1, oe_price_adjustments adj
2150: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh
2151: -- where p_request_type_code = 'ONT'
2152: --bug 3085453 handle pricing availability UI
2153: -- they pass reqtype ONT and insert adj into ldets
2154: where QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 2441: qp_list_headers_b qplh

2437: , ldet.line_detail_type_code line_detail_type_code
2438: , line.line_category
2439: , line.price_flag
2440: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet,
2441: qp_list_headers_b qplh
2442: -- where p_request_type_code <> 'ONT'
2443: --bug 3085453 handle pricing availability UI
2444: -- they pass reqtype ONT and insert adj into ldets
2445: where nvl(QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG,QP_PREQ_PUB.G_NO) <> QP_PREQ_PUB.G_YES

Line 2544: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh

2540: , ldet.line_detail_type_code line_detail_type_code
2541: , line.line_category
2542: , line.price_flag
2543: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet
2544: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh
2545: -- where p_request_type_code <> 'ONT'
2546: --bug 3085453 handle pricing availability UI
2547: -- they pass reqtype ONT and insert adj into ldets
2548: where nvl(QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG,QP_PREQ_PUB.G_NO) <> QP_PREQ_PUB.G_YES