DBA Data[Home] [Help]

APPS.OE_PRICE_ORDER_PVT_OBSOLETE dependencies on QP_LIST_LINES

Line 195: qp_list_lines ql,

191: NULL,
192: NULL,
193: px_line_adj_tbl(i).adjusted_amount --adj_iface.ADJUSTED_AMOUNT_PER_PQTY
194: From
195: qp_list_lines ql,
196: qp_list_headers_b lhdr
197: Where ql.list_line_id = px_line_adj_tbl(i).list_line_id
198: and lhdr.list_header_id = px_line_adj_tbl(i).list_header_id);
199: END IF;

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 ;