APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_PRODUCTS_V

Line 2555: OKL_PRODUCTS_V pdt

2551: khr.term_duration term,
2552: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
2553: FROM OKC_K_HEADERS_B CHR,
2554: OKL_K_HEADERS khr,
2555: OKL_PRODUCTS_V pdt
2556: WHERE CHR.id = chrid
2557: AND CHR.id = khr.id
2558: --AND khr.pdt_id = pdt.id(+);
2559: AND khr.pdt_id = pdt.id;

Line 6898: FROM okl_products_v pdt

6894: CURSOR chk_product_status (p_chr_id IN NUMBER) IS
6895: SELECT
6896: pdt.name
6897: ,pdt.PRODUCT_STATUS_CODE
6898: FROM okl_products_v pdt
6899: ,okl_k_headers_v khr
6900: ,okc_k_headers_b CHR
6901: WHERE 1=1
6902: AND khr.id = p_chr_id

Line 6906: l_product_status_code okl_products_v.PRODUCT_STATUS_CODE%TYPE;

6902: AND khr.id = p_chr_id
6903: AND pdt_id = pdt.id
6904: AND khr.id = CHR.id;
6905:
6906: l_product_status_code okl_products_v.PRODUCT_STATUS_CODE%TYPE;
6907: l_product_name okl_products_v.NAME%TYPE;
6908: BEGIN
6909:
6910: -- initialize return status

Line 6907: l_product_name okl_products_v.NAME%TYPE;

6903: AND pdt_id = pdt.id
6904: AND khr.id = CHR.id;
6905:
6906: l_product_status_code okl_products_v.PRODUCT_STATUS_CODE%TYPE;
6907: l_product_name okl_products_v.NAME%TYPE;
6908: BEGIN
6909:
6910: -- initialize return status
6911: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 7874: FROM okl_products_v pdt

7870:
7871: CURSOR chk_rpt_prod_id (p_chr_id IN NUMBER) IS
7872: SELECT
7873: pdt.reporting_pdt_id
7874: FROM okl_products_v pdt
7875: ,okl_k_headers_v khr
7876: ,okc_k_headers_b CHR
7877: WHERE 1=1
7878: AND khr.id = p_chr_id

Line 7882: l_reporting_pdt_id okl_products_v.reporting_pdt_id%TYPE;

7878: AND khr.id = p_chr_id
7879: AND pdt_id = pdt.id
7880: AND khr.id = CHR.id;
7881:
7882: l_reporting_pdt_id okl_products_v.reporting_pdt_id%TYPE;
7883:
7884:
7885: BEGIN
7886:

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

10137: l_count NUMBER := 0;
10138: l_row_notfound BOOLEAN;
10139: l_token VARCHAR2(2000);
10140:
10141: CURSOR Product_csr (p_contract_id IN okl_products_v.id%TYPE ) IS
10142: SELECT pdt.id product_id
10143: ,pdt.name product_name
10144: ,CHR.sts_code contract_status
10145: ,khr.deal_type deal_type

Line 10146: FROM okl_products_v pdt

10142: SELECT pdt.id product_id
10143: ,pdt.name product_name
10144: ,CHR.sts_code contract_status
10145: ,khr.deal_type deal_type
10146: FROM okl_products_v pdt
10147: ,okl_k_headers_v khr
10148: ,okc_k_headers_b CHR
10149: WHERE 1=1
10150: AND khr.id = p_contract_id

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

10238: AND kle.qte_id = qte.id
10239: AND chr.id = khr.id
10240: AND khr.legal_entity_id <> qte.legal_entity_id;
10241:
10242: CURSOR Product_csr (p_contract_id IN okl_products_v.id%TYPE ) IS
10243: SELECT pdt.id product_id
10244: ,pdt.name product_name
10245: ,CHR.sts_code contract_status
10246: --Bug# 4869443

Line 10250: FROM okl_products_v pdt

10246: --Bug# 4869443
10247: ,chr.start_date start_date
10248: ,chr.orig_system_source_code orig_system_source_code
10249: ,rul.rule_information1 Release_asset_yn
10250: FROM okl_products_v pdt
10251: ,okl_k_headers_v khr
10252: ,okc_k_headers_b CHR
10253: ,okc_rules_b RUL
10254: WHERE 1=1

Line 12782: FROM okl_products_v pdt

12778:
12779: CURSOR chk_product_status (p_chr_id IN NUMBER) IS
12780: SELECT
12781: pdt.name
12782: FROM okl_products_v pdt
12783: ,okl_k_headers_v khr
12784: ,okc_k_headers_b CHR
12785: WHERE 1=1
12786: AND khr.id = p_chr_id

Line 12790: l_product_name okl_products_v.NAME%TYPE;

12786: AND khr.id = p_chr_id
12787: AND pdt_id = pdt.id
12788: AND khr.id = CHR.id;
12789:
12790: l_product_name okl_products_v.NAME%TYPE;
12791: l_lne l_lne_csr%ROWTYPE;
12792:
12793: BEGIN
12794: x_return_status := Okl_Api.G_RET_STS_SUCCESS;