APPS.OE_PRICE_ORDER_PVT dependencies on QP_LIST_HEADERS_B

Line 206: qp_list_headers_b lhdr

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
210: WHEN OTHERS THEN

Line 1481: , QP_LIST_HEADERS_B QH

1477: , nvl(ldets.line_detail_type_code, 'DIS') line_detail_type_code
1478: FROM
1479: QP_LDETS_v ldets
1480: , QP_PREQ_LINES_TMP lines
1481: , QP_LIST_HEADERS_B QH
1482: WHERE
1483: ldets.list_header_id=qh.list_header_id
1484: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)
1485: 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)