APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_LIST_HEADERS_B

Line 2045: qp_list_headers_b qplh

2041: , NULL line_detail_type_code
2042: , line.line_category
2043: , line.price_flag
2044: from qp_npreq_lines_tmp line, oe_price_adjustments adj,
2045: qp_list_headers_b qplh
2046: -- where p_request_type_code = 'ONT'
2047: --bug 3085453 handle pricing availability UI
2048: -- they pass reqtype ONT and insert adj into ldets
2049: where QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 2156: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh

2152: , NULL line_detail_type_code
2153: , line.line_category
2154: , line.price_flag
2155: from qp_npreq_lines_tmp line1, oe_price_adjustments adj
2156: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh
2157: -- where p_request_type_code = 'ONT'
2158: --bug 3085453 handle pricing availability UI
2159: -- they pass reqtype ONT and insert adj into ldets
2160: where QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 2447: qp_list_headers_b qplh

2443: , ldet.line_detail_type_code line_detail_type_code
2444: , line.line_category
2445: , line.price_flag
2446: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet,
2447: qp_list_headers_b qplh
2448: -- where p_request_type_code <> 'ONT'
2449: --bug 3085453 handle pricing availability UI
2450: -- they pass reqtype ONT and insert adj into ldets
2451: where nvl(QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG,QP_PREQ_PUB.G_NO) <> QP_PREQ_PUB.G_YES

Line 2550: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh

2546: , ldet.line_detail_type_code line_detail_type_code
2547: , line.line_category
2548: , line.price_flag
2549: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet
2550: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh
2551: -- where p_request_type_code <> 'ONT'
2552: --bug 3085453 handle pricing availability UI
2553: -- they pass reqtype ONT and insert adj into ldets
2554: where nvl(QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG,QP_PREQ_PUB.G_NO) <> QP_PREQ_PUB.G_YES