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

Line 43: FROM OKL_K_HEADERS

39:
40: --Cursor to get the deal type of the contract
41: CURSOR deal_type_csr (p_chr_id IN NUMBER) IS
42: SELECT DEAL_TYPE
43: FROM OKL_K_HEADERS
44: WHERE ID = p_chr_id;
45:
46: --Cursor to get the Evergreen eligible flag
47: CURSOR eligible_csr (p_chr_id IN NUMBER) IS

Line 53: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

49: FROM OKC_RULES_B
50: WHERE RULE_INFORMATION_CATEGORY = 'LAEVEL'
51: AND DNZ_CHR_ID = p_chr_id;
52:
53: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
54:
55: BEGIN
56:
57: -- initialize return status

Line 141: FROM OKL_K_HEADERS

137:
138: --Cursor to get the deal type of the contract
139: CURSOR deal_type_csr (p_chr_id IN NUMBER) IS
140: SELECT DEAL_TYPE
141: FROM OKL_K_HEADERS
142: WHERE ID = p_chr_id;
143:
144: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
145: BEGIN

Line 144: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

140: SELECT DEAL_TYPE
141: FROM OKL_K_HEADERS
142: WHERE ID = p_chr_id;
143:
144: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
145: BEGIN
146:
147: -- initialize return status
148: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 2540: CURSOR l_hdr_csr1(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

2536: l_loan_rev_var_rate EXCEPTION;
2537: l_process_formula_exception EXCEPTION;
2538:
2539: --Bug#3877032
2540: CURSOR l_hdr_csr1(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
2541: SELECT CHR.SCS_CODE,
2542: CHR.START_DATE,
2543: CHR.END_DATE,
2544: CHR.DATE_SIGNED,

Line 2554: OKL_K_HEADERS khr,

2550: khr.DEAL_TYPE,
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(+);

Line 3839: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

3835: x_return_status OUT NOCOPY VARCHAR2,
3836: p_chr_id IN NUMBER
3837: ) IS
3838:
3839: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
3840: SELECT kle.id,
3841: kle.name
3842: FROM OKC_K_LINES_V kle,
3843: OKC_LINE_STYLES_B ls,

Line 4658: --FROM okl_k_headers_full_v

4654: --Bug#3877032
4655: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4656: SELECT NVL(okc.orig_system_source_code,'X') orig_system_source_code,
4657: NVL(okl.deal_type,'X') deal_type
4658: --FROM okl_k_headers_full_v
4659: FROM okc_k_headers_b okc,
4660: okl_k_headers okl
4661: WHERE okc.id = p_chr_id
4662: AND okc.id = okl.id;

Line 4660: okl_k_headers okl

4656: SELECT NVL(okc.orig_system_source_code,'X') orig_system_source_code,
4657: NVL(okl.deal_type,'X') deal_type
4658: --FROM okl_k_headers_full_v
4659: FROM okc_k_headers_b okc,
4660: okl_k_headers okl
4661: WHERE okc.id = p_chr_id
4662: AND okc.id = okl.id;
4663:
4664: CURSOR check_vendor_csr (p_chr_id IN NUMBER) IS

Line 4669: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

4665: SELECT 'Y'
4666: FROM okl_lessee_as_vendors_uv
4667: WHERE dnz_chr_id = p_chr_id;
4668:
4669: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
4670: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
4671: l_loan_yn VARCHAR2(1) := 'N';
4672: l_vendor_present VARCHAR2(1) := 'N';
4673:

Line 4670: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;

4666: FROM okl_lessee_as_vendors_uv
4667: WHERE dnz_chr_id = p_chr_id;
4668:
4669: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
4670: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
4671: l_loan_yn VARCHAR2(1) := 'N';
4672: l_vendor_present VARCHAR2(1) := 'N';
4673:
4674: BEGIN

Line 6631: CURSOR l_lne_pmnt_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

6627: ) IS
6628:
6629: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
6630:
6631: CURSOR l_lne_pmnt_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
6632: SELECT ls.lty_code,
6633: ls.name line_type,
6634: kle.id,
6635: kle.name

Line 6645: CURSOR l_fee_strm_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE,

6641: AND kle.dnz_chr_id = chrid
6642: AND sts.code = kle.sts_code
6643: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
6644:
6645: CURSOR l_fee_strm_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE,
6646: lineid OKC_K_LINES_B.ID%TYPE) IS
6647: SELECT itm.object1_id1
6648: FROM okc_k_items itm
6649: WHERE cle_id = lineid

Line 6653: CURSOR l_hdr_pmnt_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

6649: WHERE cle_id = lineid
6650: AND dnz_chr_id = chrid
6651: AND jtot_object1_code = 'OKL_STRMTYP';
6652:
6653: CURSOR l_hdr_pmnt_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
6654: SELECT rule.object1_id1
6655: FROM okc_rule_groups_v rgp,
6656: okc_rules_v rule
6657: WHERE rgp.id = rule.rgp_id

Line 6899: ,okl_k_headers_v khr

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
6903: AND pdt_id = pdt.id

Line 6978: from okl_k_headers

6974: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
6975:
6976: CURSOR chk_deal_type (p_chr_id IN NUMBER) IS
6977: select 'Y'
6978: from okl_k_headers
6979: where id = p_chr_id
6980: and deal_type = 'LOAN';
6981:
6982: CURSOR get_payment_lns (p_chr_id IN NUMBER) IS

Line 7382: FROM okl_k_headers_v

7378: p_chr_id IN NUMBER
7379: ) IS
7380: CURSOR l_hdr_csr IS
7381: SELECT tradein_amount
7382: FROM okl_k_headers_v
7383: WHERE id = p_chr_id;
7384: l_hdr_rec l_hdr_csr%ROWTYPE;
7385:
7386: CURSOR l_line_csr IS

Line 7820: CURSOR l_kle_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

7816:
7817: l_vendor_name po_vendors.vendor_name%TYPE;
7818:
7819:
7820: CURSOR l_kle_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
7821: SELECT NVL(kle.name,kle.item_description) name,
7822: kle.id,
7823: ls.name line_style
7824: FROM OKL_K_LINES_FULL_V kle,

Line 7843: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS

7839: l_oec number;
7840:
7841: -- Bug 5216135 : kbbhavsa : 29-May-06 : start
7842: -- cursor to fecth link line id for top line id
7843: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
7844: SELECT kle.id
7845: FROM OKL_K_LINES_FULL_V kle,
7846: OKC_LINE_STYLES_v ls,
7847: OKC_STATUSES_B sts

Line 7875: ,okl_k_headers_v khr

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
7879: AND pdt_id = pdt.id

Line 9120: * OKL_K_HEADERS_FULL_V KHR,

9116: * Cursor l_synd_csr ( chrId NUMBER ) IS
9117: * select kl.dnz_chr_id syndId
9118: * from OKC_K_ITEMS_V ITM,
9119: * OKC_K_LINES_V KL,
9120: * OKL_K_HEADERS_FULL_V KHR,
9121: * OKC_LINE_STYLES_B lse
9122: * where KL.LSE_ID=lse.id
9123: * and lse.lty_code='SHARED'
9124: * AND KL.CHR_ID =KL.DNZ_CHR_ID

Line 10147: ,okl_k_headers_v khr

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
10151: AND pdt_id = pdt.id

Line 10227: OKL_K_HEADERS khr,

10223:
10224: CURSOR con_le_roll_qt_le_csr(p_contract_id IN NUMBER) IS
10225: SELECT 1 FROM
10226: OKC_K_HEADERS_B chr,
10227: OKL_K_HEADERS khr,
10228: OKL_K_LINES kle,
10229: OKC_K_LINES_B cle,
10230: OKL_TRX_QUOTES_B qte,
10231: OKC_LINE_STYLES_B cls

Line 10251: ,okl_k_headers_v khr

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
10255: AND khr.id = p_chr_id

Line 10845: CURSOR l_lne_pmnt_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

10841: ) IS
10842:
10843: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
10844:
10845: CURSOR l_lne_pmnt_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
10846: SELECT kle.name,
10847: kle.CURRENCY_CODE,
10848: kle.id,
10849: kle.RESIDUAL_VALUE,

Line 11801: FROM OKL_K_HEADERS khr

11797:
11798: CURSOR l_chr_csr (p_chr_id NUMBER) IS
11799: SELECT khr.id,
11800: khr.deal_type
11801: FROM OKL_K_HEADERS khr
11802: WHERE khr.id = p_chr_id;
11803:
11804: CURSOR l_lne_csr (p_chr_id NUMBER) IS
11805: SELECT lne.id id,

Line 12783: ,okl_k_headers_v khr

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
12787: AND pdt_id = pdt.id