3942: pdt.id pid,
3943: chr.currency_code currency_code,
3944: khr.term_duration term,
3945: chr.orig_system_id1
3946: FROM okc_k_headers_v chr,
3947: okl_k_headers khr,
3948: okl_products_v pdt
3949: WHERE khr.id = chr.id
3950: AND chr.id = chrId
17547: pdt.id pid,
17548: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
17549: chr.currency_code currency_code,
17550: khr.term_duration term
17551: FROM okc_k_headers_v chr,
17552: okl_k_headers khr,
17553: okl_products_v pdt
17554: WHERE khr.id = chr.id
17555: AND chr.id = chrId
21881: pdt.id pid,
21882: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
21883: chr.currency_code currency_code,
21884: khr.term_duration term
21885: FROM okc_k_headers_v chr,
21886: okl_k_headers khr,
21887: okl_products_v pdt
21888: WHERE khr.id = chr.id
21889: AND chr.id = chrId