APPS.OE_PRICE_ORDER_PVT dependencies on QP_LIST_LINES

Line 205: qp_list_lines ql,

201: G_LDET_CHARGE_TYPE_CODE(j),
202: G_LDET_CHARGE_SUBTYPE_CODE(j),
203: G_LDET_OVERRIDE_FLAG(j)
204: From
205: qp_list_lines ql,
206: qp_list_headers_b lhdr
207: Where ql.list_line_id = px_line_adj_tbl(i).list_line_id
208: and lhdr.list_header_id = px_line_adj_tbl(i).list_header_id;
209: EXCEPTION

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 ;