APPS.OE_ORDER_PRICE_PVT dependencies on QP_LIST_HEADERS_VL

Line 209: qp_list_headers_vl c

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

Line 7333: from qp_list_headers_vl where

7329:
7330: l_invalid_line := 'Y';
7331: Begin
7332: Select name into l_price_list
7333: from qp_list_headers_vl where
7334: list_header_id = l_line_rec.price_list_id;
7335: Exception When No_data_found then
7336: l_price_list := l_line_rec.price_list_id;
7337: End;

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 ;