APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_LIST_LINES

Line 201: ,qp_list_lines ql_det

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

Line 203: , qp_list_lines ql

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

Line 301: , qp_list_lines ql

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

Line 385: , qp_list_lines ql

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

Line 476: , qp_list_lines ql

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

Line 567: , qp_list_lines ql

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

Line 651: , qp_list_lines ql

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

Line 2984: from qp_list_lines

2980:
2981: if l_net_amount_flag_tbl(i) is null then
2982: select net_amount_flag
2983: into l_net_amount_flag_tbl(i)
2984: from qp_list_lines
2985: where list_line_id = l_list_line_id_tbl(i);
2986: end if;
2987:
2988: if l_net_amount_flag_tbl(i) = 'Y' then