APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_PRODUCTS

Line 159: OKL_PRODUCTS_V pdt

155: khr.term_duration term,
156: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
157: FROM OKC_K_HEADERS_B chr,
158: OKL_K_HEADERS khr,
159: OKL_PRODUCTS_V pdt
160: WHERE chr.id = chrid
161: AND chr.id = khr.id
162: --AND khr.pdt_id = pdt.id(+);
163: AND khr.pdt_id = pdt.id;

Line 459: FROM okl_products prod, okl_k_headers_full_v khr

455: AND tl.LANGUAGE = 'US';
456:
457: CURSOR l_product_csr (p_chr_id number) IS
458: SELECT khr.pdt_id, khr.start_date, prod.reporting_pdt_id
459: FROM okl_products prod, okl_k_headers_full_v khr
460: WHERE khr.ID = p_chr_id AND prod.ID = khr.pdt_id;
461:
462:
463: CURSOR l_rep_strm_csr (rep_pdt_id number,styid number,primary_sty_purpose