eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_K_HEADERS_V

Line 7286: ,okl_k_headers_v khr

7282: SELECT
7283: pdt.name
7284: ,pdt.PRODUCT_STATUS_CODE
7285: FROM okl_products_v pdt
7286: ,okl_k_headers_v khr
7287: ,okc_k_headers_b CHR
7288: WHERE 1=1
7289: AND khr.id = p_chr_id
7290: AND pdt_id = pdt.id

Line 7776: FROM okl_k_headers_v

7772: p_chr_id IN NUMBER
7773: ) IS
7774: CURSOR l_hdr_csr IS
7775: SELECT tradein_amount
7776: FROM okl_k_headers_v
7777: WHERE id = p_chr_id;
7778: l_hdr_rec l_hdr_csr%ROWTYPE;
7779:
7780: CURSOR l_line_csr IS

Line 8292: ,okl_k_headers_v khr

8288: CURSOR chk_rpt_prod_id (p_chr_id IN NUMBER) IS
8289: SELECT
8290: pdt.reporting_pdt_id
8291: FROM okl_products_v pdt
8292: ,okl_k_headers_v khr
8293: ,okc_k_headers_b CHR
8294: WHERE 1=1
8295: AND khr.id = p_chr_id
8296: AND pdt_id = pdt.id

Line 10568: ,okl_k_headers_v khr

10564: ,pdt.name product_name
10565: ,CHR.sts_code contract_status
10566: ,khr.deal_type deal_type
10567: FROM okl_products_v pdt
10568: ,okl_k_headers_v khr
10569: ,okc_k_headers_b CHR
10570: WHERE 1=1
10571: AND khr.id = p_contract_id
10572: AND pdt_id = pdt.id

Line 13335: ,okl_k_headers_v khr

13331: CURSOR chk_product_status (p_chr_id IN NUMBER) IS
13332: SELECT
13333: pdt.name
13334: FROM okl_products_v pdt
13335: ,okl_k_headers_v khr
13336: ,okc_k_headers_b CHR
13337: WHERE 1=1
13338: AND khr.id = p_chr_id
13339: AND pdt_id = pdt.id