DBA Data[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on QP_LIST_LINES

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

7117:
7118: Function get_formula(p_line_index In Number) Return Varchar2 IS
7119: Cursor Get_Formula Is
7120: Select f.formula
7121: From qp_ldets_v ldet, qp_list_lines qpll, qp_price_formulas_vl f
7122: Where ldet.line_index = p_line_index
7123: AND ldet.list_line_id = qpll.list_line_id
7124: AND f.price_formula_id = nvl(qpll.price_by_formula_id,qpll.generate_using_formula_id);
7125: l_formula_name Varchar2(2000);

Line 7481: from qp_list_headers_vl a,qp_list_lines b where

7477: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
7478:
7479: Begin
7480: Select name into l_price_list
7481: from qp_list_headers_vl a,qp_list_lines b where
7482: b.list_line_id = to_number(substr(wrong_line.status_text,1,
7483: instr(wrong_line.status_text,',')-1))
7484: and a.list_header_id=b.list_header_id
7485: ;

Line 7499: from qp_list_headers_vl a,qp_list_lines b where

7495: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',
7496: '( '||l_line_rec.Ordered_Item||' ) '||l_price_list);
7497: Begin
7498: Select name into l_price_list
7499: from qp_list_headers_vl a,qp_list_lines b where
7500: b.list_line_id =
7501: to_number(substr(wrong_line.status_text,
7502: instr(wrong_line.status_text,',')+1))
7503: and a.list_header_id=b.list_header_id ;