DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on QP_LIST_LINES

Line 7975: , qp_list_lines qpll

7971: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
7972: From
7973: qp_qualifiers qpq
7974: , qp_pricing_attributes qppa
7975: , qp_list_lines qpll
7976: , qp_list_headers_b qplh
7977: , qp_price_req_sources qpprs
7978: where
7979: qpq.qualifier_context='CUSTOMER'

Line 9344: from qp_list_headers_vl a,qp_list_lines b where

9340: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
9341:
9342: Begin
9343: Select name into l_price_list
9344: from qp_list_headers_vl a,qp_list_lines b where
9345: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,1,
9346: instr(p_req_line_tbl(i).status_text,',')-1))
9347: and a.list_header_id=b.list_header_id
9348: ;

Line 9362: from qp_list_headers_vl a,qp_list_lines b where

9358: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||l_line_rec.Ordered_Item||' ) '||
9359: l_price_list);
9360: Begin
9361: Select name into l_price_list
9362: from qp_list_headers_vl a,qp_list_lines b where
9363: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,
9364: instr(p_req_line_tbl(i).status_text,',')+1))
9365: and a.list_header_id=b.list_header_id ;
9366: Exception When No_data_found then

Line 12733: from QP_PREQ_LINES_TMP l, QP_PREQ_LDETS_TMP ld, QP_LIST_LINES ll

12729: ld.pricing_phase_id, ll.override_flag, ld.operand_calculation_code,
12730: ld.ADJUSTMENT_AMOUNT, ll.CHARGE_TYPE_CODE, ll.CHARGE_SUBTYPE_CODE,
12731: l.line_type_code, l.line_id, ld.PRICE_BREAK_TYPE_CODE,
12732: ld.pricing_group_sequence
12733: from QP_PREQ_LINES_TMP l, QP_PREQ_LDETS_TMP ld, QP_LIST_LINES ll
12734: where l.line_index = ld.line_index
12735: and ld.CREATED_FROM_LIST_LINE_ID = ll.LIST_LINE_ID
12736: and ld.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
12737: ORDER BY ld.list_line_no; -- bug 6323362

Line 13472: qp_list_lines ql,

13468: CURSOR l_send_all_lines_cur(p_event_code1 VARCHAR2) IS
13469: SELECT 'X'
13470: FROM
13471: qp_list_headers_b qh,
13472: qp_list_lines ql,
13473: qp_pricing_attributes qppr
13474: WHERE ql.list_line_id = qppr.list_line_id
13475: AND ql.automatic_flag = 'N'
13476: AND qh.list_header_id = ql.list_header_id