APPS.OE_ORDER_ADJ_PVT dependencies on QP_LIST_HEADERS_VL

Line 299: qp_list_headers_vl c

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

Line 9254: from qp_list_headers_vl where

9250:
9251: l_invalid_line := 'Y';
9252: Begin
9253: Select name into l_price_list
9254: from qp_list_headers_vl where
9255: list_header_id = l_line_rec.price_list_id;
9256: Exception When No_data_found then
9257: l_price_list := l_line_rec.price_list_id;
9258: End;

Line 9344: from qp_list_headers_vl a,qp_list_lines b where

9340: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
9341:
9342: Begin
9343: Select name into l_price_list
9344: from qp_list_headers_vl a,qp_list_lines b where
9345: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,1,
9346: instr(p_req_line_tbl(i).status_text,',')-1))
9347: and a.list_header_id=b.list_header_id
9348: ;

Line 9362: from qp_list_headers_vl a,qp_list_lines b where

9358: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||l_line_rec.Ordered_Item||' ) '||
9359: l_price_list);
9360: Begin
9361: Select name into l_price_list
9362: from qp_list_headers_vl a,qp_list_lines b where
9363: b.list_line_id = to_number(substr(p_req_line_tbl(i).status_text,
9364: instr(p_req_line_tbl(i).status_text,',')+1))
9365: and a.list_header_id=b.list_header_id ;
9366: Exception When No_data_found then