APPS.OE_ORDER_ADJ_PVT dependencies on QP_LIST_HEADERS_VL

Line 298: qp_list_headers_vl c

294: Select c.name,
295: a.list_line_no
296: From qp_preq_ldets_tmp a,
297: qp_preq_lines_tmp b,
298: qp_list_headers_vl c
299: Where b.line_id = p_line_id
300: And b.line_index = a.line_index
301: And a.created_from_list_header_id = c.list_header_id
302: And a.automatic_flag = 'Y'

Line 9162: from qp_list_headers_vl where

9158:
9159: l_invalid_line := 'Y';
9160: Begin
9161: Select name into l_price_list
9162: from qp_list_headers_vl where
9163: list_header_id = l_line_rec.price_list_id;
9164: Exception When No_data_found then
9165: l_price_list := l_line_rec.price_list_id;
9166: End;

Line 9253: from qp_list_headers_vl a,qp_list_lines b where

9249: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
9250:
9251: Begin
9252: Select name into l_price_list
9253: from qp_list_headers_vl a,qp_list_lines b where
9254: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,1,
9255: instr(p_req_line_tbl(i).status_text,',')-1))
9256: and a.list_header_id=b.list_header_id
9257: ;

Line 9271: from qp_list_headers_vl a,qp_list_lines b where

9267: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||l_line_rec.Ordered_Item||' ) '||
9268: l_price_list);
9269: Begin
9270: Select name into l_price_list
9271: from qp_list_headers_vl a,qp_list_lines b where
9272: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,
9273: instr(p_req_line_tbl(i).status_text,',')+1))
9274: and a.list_header_id=b.list_header_id ;
9275: Exception When No_data_found then