APPS.OE_PRICE_ORDER_PVT dependencies on QP_LIST_HEADERS_VL

Line 1057: from qp_list_headers_vl where

1053:
1054: l_invalid_line := 'Y';
1055: Begin
1056: Select name into l_price_list
1057: from qp_list_headers_vl where
1058: list_header_id = l_line_rec.price_list_id;
1059: Exception When No_data_found then
1060: l_price_list := l_line_rec.price_list_id;
1061: End;

Line 1182: from qp_list_headers_vl a,qp_list_lines b where

1178: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
1179:
1180: Begin
1181: Select name into l_price_list
1182: from qp_list_headers_vl a,qp_list_lines b where
1183: b.list_line_id = to_number(substr(wrong_line.status_text,1,
1184: instr(wrong_line.status_text,',')-1))
1185: and a.list_header_id=b.list_header_id
1186: ;

Line 1200: from qp_list_headers_vl a,qp_list_lines b where

1196: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',
1197: '( '||l_line_rec.Ordered_Item||' ) '||l_price_list);
1198: Begin
1199: Select name into l_price_list
1200: from qp_list_headers_vl a,qp_list_lines b where
1201: b.list_line_id =
1202: to_number(substr(wrong_line.status_text,
1203: instr(wrong_line.status_text,',')+1))
1204: and a.list_header_id=b.list_header_id ;

Line 1569: from qp_list_headers_vl

1565:
1566: IF (l_adj_tbl(i).list_header_id IS NOT NULL) THEN
1567: SELECT name
1568: INTO l_adj_tbl(i).attribute1
1569: from qp_list_headers_vl
1570: where list_header_id = l_adj_tbl(i).list_header_id;
1571: END IF;
1572:
1573: IF (l_adj_tbl(i).arithmetic_operator IS NOT NULL) THEN