APPS.OE_ORDER_PRICE_PVT dependencies on QP_LIST_LINES

Line 6842: From qp_ldets_v ldet, qp_list_lines qpll, qp_price_formulas_vl f

6838:
6839: Function get_formula(p_line_index In Number) Return Varchar2 IS
6840: Cursor Get_Formula Is
6841: Select f.formula
6842: From qp_ldets_v ldet, qp_list_lines qpll, qp_price_formulas_vl f
6843: Where ldet.line_index = p_line_index
6844: AND ldet.list_line_id = qpll.list_line_id
6845: AND f.price_formula_id = nvl(qpll.price_by_formula_id,qpll.generate_using_formula_id);
6846: l_formula_name Varchar2(2000);

Line 7194: from qp_list_headers_vl a,qp_list_lines b where

7190: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
7191:
7192: Begin
7193: Select name into l_price_list
7194: from qp_list_headers_vl a,qp_list_lines b where
7195: b.list_line_id = to_number(substr(wrong_line.status_text,1,
7196: instr(wrong_line.status_text,',')-1))
7197: and a.list_header_id=b.list_header_id
7198: ;

Line 7212: from qp_list_headers_vl a,qp_list_lines b where

7208: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',
7209: '( '||l_line_rec.Ordered_Item||' ) '||l_price_list);
7210: Begin
7211: Select name into l_price_list
7212: from qp_list_headers_vl a,qp_list_lines b where
7213: b.list_line_id =
7214: to_number(substr(wrong_line.status_text,
7215: instr(wrong_line.status_text,',')+1))
7216: and a.list_header_id=b.list_header_id ;