APPS.OE_BULK_PRICEORDER_PVT dependencies on QP_LIST_HEADERS_VL

Line 858: qp_list_headers_vl c

854: Select c.name,
855: a.list_line_no
856: From qp_preq_ldets_tmp a,
857: qp_preq_lines_tmp b,
858: qp_list_headers_vl c
859: Where b.line_id = p_line_id
860: And b.line_index = a.line_index
861: And a.created_from_list_header_id = c.list_header_id
862: And a.automatic_flag = 'Y'

Line 1033: from qp_list_headers_vl where

1029:
1030: l_invalid_line := 'Y';
1031: Begin
1032: Select name into l_price_list
1033: from qp_list_headers_vl where
1034: list_header_id = l_price_list_id;
1035: Exception When No_data_found then
1036: l_price_list := l_price_list_id;
1037: End;

Line 1097: from qp_list_headers_vl a,qp_list_lines b where

1093: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
1094:
1095: Begin
1096: Select name into l_price_list
1097: from qp_list_headers_vl a,qp_list_lines b where
1098: b.list_line_id = to_number(substr(wrong_line.status_text,1,
1099: instr(wrong_line.status_text,',')-1))
1100: and a.list_header_id=b.list_header_id
1101: ;

Line 1119: from qp_list_headers_vl a,qp_list_lines b where

1115:
1116:
1117: Begin
1118: Select name into l_price_list
1119: from qp_list_headers_vl a,qp_list_lines b where
1120: b.list_line_id =
1121: to_number(substr(wrong_line.status_text,
1122: instr(wrong_line.status_text,',')+1))
1123: and a.list_header_id=b.list_header_id ;