APPS.OE_PRICE_ORDER_PVT_OBSOLETE dependencies on QP_LIST_HEADERS_VL

Line 851: from qp_list_headers_vl where

847:
848: l_invalid_line := 'Y';
849: Begin
850: Select name into l_price_list
851: from qp_list_headers_vl where
852: list_header_id = l_line_rec.price_list_id;
853: Exception When No_data_found then
854: l_price_list := l_line_rec.price_list_id;
855: End;

Line 976: from qp_list_headers_vl a,qp_list_lines b where

972: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
973:
974: Begin
975: Select name into l_price_list
976: from qp_list_headers_vl a,qp_list_lines b where
977: b.list_line_id = to_number(substr(wrong_line.status_text,1,
978: instr(wrong_line.status_text,',')-1))
979: and a.list_header_id=b.list_header_id
980: ;

Line 994: from qp_list_headers_vl a,qp_list_lines b where

990: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',
991: '( '||l_line_rec.Ordered_Item||' ) '||l_price_list);
992: Begin
993: Select name into l_price_list
994: from qp_list_headers_vl a,qp_list_lines b where
995: b.list_line_id =
996: to_number(substr(wrong_line.status_text,
997: instr(wrong_line.status_text,',')+1))
998: and a.list_header_id=b.list_header_id ;

Line 1346: from qp_list_headers_vl

1342: -- ,l_adj_tbl(i).LOCK_CONTROL*/
1343: IF (l_adj_tbl(i).list_header_id IS NOT NULL) THEN
1344: SELECT name
1345: INTO l_adj_tbl(i).attribute1
1346: from qp_list_headers_vl
1347: where list_header_id = l_adj_tbl(i).list_header_id;
1348: END IF;
1349:
1350: IF (l_adj_tbl(i).arithmetic_operator IS NOT NULL) THEN