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_PRODUCTS_V

Line 2712: OKL_PRODUCTS_V pdt

2708: khr.term_duration term,
2709: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
2710: FROM OKC_K_HEADERS_B CHR,
2711: OKL_K_HEADERS khr,
2712: OKL_PRODUCTS_V pdt
2713: WHERE CHR.id = chrid
2714: AND CHR.id = khr.id
2715: --AND khr.pdt_id = pdt.id(+);
2716: AND khr.pdt_id = pdt.id;

Line 7285: FROM okl_products_v pdt

7281: CURSOR chk_product_status (p_chr_id IN NUMBER) IS
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

Line 7293: l_product_status_code okl_products_v.PRODUCT_STATUS_CODE%TYPE;

7289: AND khr.id = p_chr_id
7290: AND pdt_id = pdt.id
7291: AND khr.id = CHR.id;
7292:
7293: l_product_status_code okl_products_v.PRODUCT_STATUS_CODE%TYPE;
7294: l_product_name okl_products_v.NAME%TYPE;
7295: BEGIN
7296:
7297: -- initialize return status

Line 7294: l_product_name okl_products_v.NAME%TYPE;

7290: AND pdt_id = pdt.id
7291: AND khr.id = CHR.id;
7292:
7293: l_product_status_code okl_products_v.PRODUCT_STATUS_CODE%TYPE;
7294: l_product_name okl_products_v.NAME%TYPE;
7295: BEGIN
7296:
7297: -- initialize return status
7298: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 8291: FROM okl_products_v pdt

8287:
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

Line 8299: l_reporting_pdt_id okl_products_v.reporting_pdt_id%TYPE;

8295: AND khr.id = p_chr_id
8296: AND pdt_id = pdt.id
8297: AND khr.id = CHR.id;
8298:
8299: l_reporting_pdt_id okl_products_v.reporting_pdt_id%TYPE;
8300:
8301:
8302: BEGIN
8303:

Line 10562: CURSOR Product_csr (p_contract_id IN okl_products_v.id%TYPE ) IS

10558: l_count NUMBER := 0;
10559: l_row_notfound BOOLEAN;
10560: l_token VARCHAR2(2000);
10561:
10562: CURSOR Product_csr (p_contract_id IN okl_products_v.id%TYPE ) IS
10563: SELECT pdt.id product_id
10564: ,pdt.name product_name
10565: ,CHR.sts_code contract_status
10566: ,khr.deal_type deal_type

Line 10567: FROM okl_products_v pdt

10563: SELECT pdt.id product_id
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

Line 10671: FROM okl_products_v pdt

10667: ,CHR.sts_code contract_status
10668: --Bug# 4869443
10669: ,chr.start_date start_date
10670: ,chr.orig_system_source_code orig_system_source_code
10671: FROM okl_products_v pdt
10672: ,okl_k_headers khr
10673: ,okc_k_headers_b CHR
10674: WHERE khr.id = p_chr_id
10675: AND khr.pdt_id = pdt.id

Line 13334: FROM okl_products_v pdt

13330:
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

Line 13342: l_product_name okl_products_v.NAME%TYPE;

13338: AND khr.id = p_chr_id
13339: AND pdt_id = pdt.id
13340: AND khr.id = CHR.id;
13341:
13342: l_product_name okl_products_v.NAME%TYPE;
13343: l_lne l_lne_csr%ROWTYPE;
13344:
13345: BEGIN
13346: x_return_status := Okl_Api.G_RET_STS_SUCCESS;