[Home] [Help]
7879: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
7880: From
7881: qp_qualifiers qpq
7882: , qp_pricing_attributes qppa
7883: , qp_list_lines qpll
7884: , qp_list_headers_b qplh
7885: , qp_price_req_sources qpprs
7886: where
7887: qpq.qualifier_context='CUSTOMER'
9249: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
9250:
9251: Begin
9252: Select name into l_price_list
9253: from qp_list_headers_vl a,qp_list_lines b where
9254: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,1,
9255: instr(p_req_line_tbl(i).status_text,',')-1))
9256: and a.list_header_id=b.list_header_id
9257: ;
9267: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||l_line_rec.Ordered_Item||' ) '||
9268: l_price_list);
9269: Begin
9270: Select name into l_price_list
9271: from qp_list_headers_vl a,qp_list_lines b where
9272: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,
9273: instr(p_req_line_tbl(i).status_text,',')+1))
9274: and a.list_header_id=b.list_header_id ;
9275: Exception When No_data_found then
12574: ld.pricing_phase_id, ll.override_flag, ld.operand_calculation_code,
12575: ld.ADJUSTMENT_AMOUNT, ll.CHARGE_TYPE_CODE, ll.CHARGE_SUBTYPE_CODE,
12576: l.line_type_code, l.line_id, ld.PRICE_BREAK_TYPE_CODE,
12577: ld.pricing_group_sequence
12578: from QP_PREQ_LINES_TMP l, QP_PREQ_LDETS_TMP ld, QP_LIST_LINES ll
12579: where l.line_index = ld.line_index
12580: and ld.CREATED_FROM_LIST_LINE_ID = ll.LIST_LINE_ID
12581: and ld.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
12582: ORDER BY ld.list_line_no; -- bug 6323362
13294: CURSOR l_send_all_lines_cur(p_event_code1 VARCHAR2) IS
13295: SELECT 'X'
13296: FROM
13297: qp_list_headers_b qh,
13298: qp_list_lines ql,
13299: qp_pricing_attributes qppr
13300: WHERE ql.list_line_id = qppr.list_line_id
13301: AND ql.automatic_flag = 'N'
13302: AND qh.list_header_id = ql.list_header_id