APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_LIST_LINES

Line 204: ,qp_list_lines ql_det

200: , oe_price_adjustments adj
201: -- Begin Bug No: 6753550
202: --,qp_ldets_v ldet
203: ,qp_npreq_ldets_tmp ldet
204: ,qp_list_lines ql_det
205: -- End Bug No: 6753550
206: , qp_list_lines ql
207: -- WHERE p_request_type_code = 'ONT'
208: --bug 3085453 handle pricing availability UI

Line 206: , qp_list_lines ql

202: --,qp_ldets_v ldet
203: ,qp_npreq_ldets_tmp ldet
204: ,qp_list_lines ql_det
205: -- End Bug No: 6753550
206: , qp_list_lines ql
207: -- WHERE p_request_type_code = 'ONT'
208: --bug 3085453 handle pricing availability UI
209: -- they pass reqtype ONT and insert adj into ldets
210: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 305: , qp_list_lines ql

301: , adj.operand adj_ord_qty_operand
302: FROM qp_npreq_lines_tmp line
303: , oe_price_adjustments adj
304: ,qp_ldets_v ldet
305: , qp_list_lines ql
306: -- WHERE p_request_type_code = 'ONT'
307: --bug 3085453 handle pricing availability UI
308: -- they pass reqtype ONT and insert adj into ldets
309: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 389: , qp_list_lines ql

385: , adj.order_qty_operand adj_ord_qty_operand
386: FROM qp_npreq_lines_tmp line
387: , qp_npreq_ldets_tmp adj
388: ,qp_ldets_v ldet
389: , qp_list_lines ql
390: -- WHERE p_request_type_code <> 'ONT'
391: --bug 3085453 handle pricing availability UI
392: -- they pass reqtype ONT and insert adj into ldets
393: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG <> QP_PREQ_PUB.G_YES

Line 480: , qp_list_lines ql

476: , adj.operand adj_ord_qty_operand
477: FROM qp_int_lines line
478: , oe_price_adjustments adj
479: ,qp_ldets_v ldet
480: , qp_list_lines ql
481: -- WHERE p_request_type_code = 'ONT'
482: --bug 3085453 handle pricing availability UI
483: -- they pass reqtype ONT and insert adj into ldets
484: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 571: , qp_list_lines ql

567: , adj.operand adj_ord_qty_operand
568: FROM qp_int_lines line
569: , oe_price_adjustments adj
570: ,qp_ldets_v ldet
571: , qp_list_lines ql
572: -- WHERE p_request_type_code = 'ONT'
573: --bug 3085453 handle pricing availability UI
574: -- they pass reqtype ONT and insert adj into ldets
575: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 655: , qp_list_lines ql

651: , adj.order_qty_operand adj_ord_qty_operand
652: FROM qp_int_lines line
653: , qp_int_ldets adj
654: ,qp_ldets_v ldet
655: , qp_list_lines ql
656: -- WHERE p_request_type_code <> 'ONT'
657: --bug 3085453 handle pricing availability UI
658: -- they pass reqtype ONT and insert adj into ldets
659: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG <> QP_PREQ_PUB.G_YES

Line 3030: from qp_list_lines

3026:
3027: if l_net_amount_flag_tbl(i) is null then
3028: select net_amount_flag
3029: into l_net_amount_flag_tbl(i)
3030: from qp_list_lines
3031: where list_line_id = l_list_line_id_tbl(i);
3032: end if;
3033:
3034: if l_net_amount_flag_tbl(i) = 'Y' then