APPS.OE_PRICE_ORDER_PVT_OBSOLETE dependencies on QP_LIST_HEADERS_B

Line 196: qp_list_headers_b lhdr

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;
200: i := px_line_adj_tbl.next(i);

Line 1272: , QP_LIST_HEADERS_B QH

1268: , ldets.adjustment_amount adjusted_amount_per_pqty
1269: FROM
1270: QP_LDETS_v ldets
1271: , QP_PREQ_LINES_TMP lines
1272: , QP_LIST_HEADERS_B QH
1273: WHERE
1274: ldets.list_header_id=qh.list_header_id
1275: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)
1276: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)