APPS.OE_ORDER_PRICE_PVT dependencies on QP_LIST_HEADERS_VL

Line 208: qp_list_headers_vl c

204: Select c.name,
205: a.list_line_no
206: From qp_preq_ldets_tmp a,
207: qp_preq_lines_tmp b,
208: qp_list_headers_vl c
209: Where b.line_id = p_line_id
210: And b.line_index = a.line_index
211: And a.created_from_list_header_id = c.list_header_id
212: And a.automatic_flag = 'Y'

Line 7051: from qp_list_headers_vl where

7047:
7048: l_invalid_line := 'Y';
7049: Begin
7050: Select name into l_price_list
7051: from qp_list_headers_vl where
7052: list_header_id = l_line_rec.price_list_id;
7053: Exception When No_data_found then
7054: l_price_list := l_line_rec.price_list_id;
7055: End;

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 ;