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 2697: CURSOR l_hdr_csr1(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

2693: l_loan_rev_var_rate EXCEPTION;
2694: l_process_formula_exception EXCEPTION;
2695:
2696: --Bug#3877032
2697: CURSOR l_hdr_csr1(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
2698: SELECT CHR.SCS_CODE,
2699: CHR.START_DATE,
2700: CHR.END_DATE,
2701: CHR.DATE_SIGNED,

Line 2711: OKL_K_HEADERS khr,

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

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

4157: x_return_status OUT NOCOPY VARCHAR2,
4158: p_chr_id IN NUMBER
4159: ) IS
4160:
4161: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
4162: SELECT kle.id,
4163: kle.name
4164: FROM OKC_K_LINES_V kle,
4165: OKC_LINE_STYLES_B ls,

Line 5045: --FROM okl_k_headers_full_v

5041: --Bug#3877032
5042: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5043: SELECT NVL(okc.orig_system_source_code,'X') orig_system_source_code,
5044: NVL(okl.deal_type,'X') deal_type
5045: --FROM okl_k_headers_full_v
5046: FROM okc_k_headers_b okc,
5047: okl_k_headers okl
5048: WHERE okc.id = p_chr_id
5049: AND okc.id = okl.id;

Line 5047: okl_k_headers okl

5043: SELECT NVL(okc.orig_system_source_code,'X') orig_system_source_code,
5044: NVL(okl.deal_type,'X') deal_type
5045: --FROM okl_k_headers_full_v
5046: FROM okc_k_headers_b okc,
5047: okl_k_headers okl
5048: WHERE okc.id = p_chr_id
5049: AND okc.id = okl.id;
5050:
5051: CURSOR check_vendor_csr (p_chr_id IN NUMBER) IS

Line 5056: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

5052: SELECT 'Y'
5053: FROM okl_lessee_as_vendors_uv
5054: WHERE dnz_chr_id = p_chr_id;
5055:
5056: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
5057: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
5058: l_loan_yn VARCHAR2(1) := 'N';
5059: l_vendor_present VARCHAR2(1) := 'N';
5060:

Line 5057: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;

5053: FROM okl_lessee_as_vendors_uv
5054: WHERE dnz_chr_id = p_chr_id;
5055:
5056: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
5057: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
5058: l_loan_yn VARCHAR2(1) := 'N';
5059: l_vendor_present VARCHAR2(1) := 'N';
5060:
5061: BEGIN

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

7014: ) IS
7015:
7016: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
7017:
7018: CURSOR l_lne_pmnt_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
7019: SELECT ls.lty_code,
7020: ls.name line_type,
7021: kle.id,
7022: kle.name

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

7028: AND kle.dnz_chr_id = chrid
7029: AND sts.code = kle.sts_code
7030: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
7031:
7032: CURSOR l_fee_strm_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE,
7033: lineid OKC_K_LINES_B.ID%TYPE) IS
7034: SELECT itm.object1_id1
7035: FROM okc_k_items itm
7036: WHERE cle_id = lineid

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

7036: WHERE cle_id = lineid
7037: AND dnz_chr_id = chrid
7038: AND jtot_object1_code = 'OKL_STRMTYP';
7039:
7040: CURSOR l_hdr_pmnt_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
7041: SELECT rule.object1_id1
7042: FROM okc_rule_groups_v rgp,
7043: okc_rules_v rule
7044: WHERE rgp.id = rule.rgp_id

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 7365: from okl_k_headers

7361: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
7362:
7363: CURSOR chk_deal_type (p_chr_id IN NUMBER) IS
7364: select 'Y'
7365: from okl_k_headers
7366: where id = p_chr_id
7367: and deal_type = 'LOAN';
7368:
7369: CURSOR get_payment_lns (p_chr_id IN NUMBER) IS

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 8237: CURSOR l_kle_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

8233:
8234: l_vendor_name po_vendors.vendor_name%TYPE;
8235:
8236:
8237: CURSOR l_kle_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
8238: SELECT NVL(kle.name,kle.item_description) name,
8239: kle.id,
8240: ls.name line_style
8241: FROM OKL_K_LINES_FULL_V kle,

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

8256: l_oec number;
8257:
8258: -- Bug 5216135 : kbbhavsa : 29-May-06 : start
8259: -- cursor to fecth link line id for top line id
8260: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
8261: SELECT kle.id
8262: FROM OKL_K_LINES_FULL_V kle,
8263: OKC_LINE_STYLES_v ls,
8264: OKC_STATUSES_B sts

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 9541: * OKL_K_HEADERS_FULL_V KHR,

9537: * Cursor l_synd_csr ( chrId NUMBER ) IS
9538: * select kl.dnz_chr_id syndId
9539: * from OKC_K_ITEMS_V ITM,
9540: * OKC_K_LINES_V KL,
9541: * OKL_K_HEADERS_FULL_V KHR,
9542: * OKC_LINE_STYLES_B lse
9543: * where KL.LSE_ID=lse.id
9544: * and lse.lty_code='SHARED'
9545: * AND KL.CHR_ID =KL.DNZ_CHR_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 10648: OKL_K_HEADERS khr,

10644:
10645: CURSOR con_le_roll_qt_le_csr(p_contract_id IN NUMBER) IS
10646: SELECT 1 FROM
10647: OKC_K_HEADERS_B chr,
10648: OKL_K_HEADERS khr,
10649: OKL_K_LINES kle,
10650: OKC_K_LINES_B cle,
10651: OKL_TRX_QUOTES_B qte,
10652: OKC_LINE_STYLES_B cls

Line 10672: ,okl_k_headers khr

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
10676: AND khr.id = CHR.id;

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

11264: ) IS
11265:
11266: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
11267:
11268: CURSOR l_lne_pmnt_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
11269: SELECT kle.name,
11270: kle.CURRENCY_CODE,
11271: kle.id,
11272: kle.RESIDUAL_VALUE,

Line 12224: FROM OKL_K_HEADERS khr

12220:
12221: CURSOR l_chr_csr (p_chr_id NUMBER) IS
12222: SELECT khr.id,
12223: khr.deal_type
12224: FROM OKL_K_HEADERS khr
12225: WHERE khr.id = p_chr_id;
12226:
12227: CURSOR l_lne_csr (p_chr_id NUMBER) IS
12228: SELECT lne.id 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

Line 13497: FROM okl_k_headers khr

13493: ) IS
13494:
13495: CURSOR l_chr_csr(p_chr_id IN NUMBER) IS
13496: SELECT khr.expected_delivery_date
13497: FROM okl_k_headers khr
13498: WHERE khr.id = p_chr_id;
13499:
13500: l_chr_rec l_chr_csr%ROWTYPE;
13501: /*Commented as part of Bug# 15992711