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_LA_SALES_TAX_PVT dependencies on OKL_K_LINES

Line 311: FROM okl_k_lines kle

307: FROM okc_k_headers_b CHR
308: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
309: and chr.ID = cp_chr_id
310: AND exists ( SELECT '1'
311: FROM okl_k_lines kle
312: ,okc_k_lines_b cleb
313: WHERE cleb.dnz_chr_id = chr.id
314: AND cleb.chr_id = chr.id
315: AND cleb.id = kle.id

Line 320: FROM okl_k_lines kle

316: AND cleb.lse_id = 33
317: AND cleb.sts_code <> 'ABANDONED'
318: AND nvl(kle.re_lease_yn,'N') = 'Y')
319: AND exists ( SELECT '1'
320: FROM okl_k_lines kle
321: ,okc_k_lines_b cleb
322: WHERE cleb.dnz_chr_id = chr.id
323: AND cleb.chr_id = chr.id
324: AND cleb.id = kle.id

Line 337: FROM okl_k_lines kle

333: and chr.ID = ( SELECT orig_system_id1
334: FROM okc_k_headers_b
335: WHERE id = cp_chr_id )
336: AND exists ( SELECT '1'
337: FROM okl_k_lines kle
338: ,okc_k_lines_b cleb
339: WHERE cleb.dnz_chr_id = chr.id
340: AND cleb.chr_id = chr.id
341: AND cleb.id = kle.id

Line 346: FROM okl_k_lines kle

342: AND cleb.lse_id = 33
343: AND cleb.sts_code <> 'ABANDONED'
344: AND nvl(kle.re_lease_yn,'N') = 'Y')
345: AND not exists ( SELECT '1'
346: FROM okl_k_lines kle
347: ,okc_k_lines_b cleb
348: WHERE cleb.dnz_chr_id = chr.id
349: AND cleb.chr_id = chr.id
350: AND cleb.id = kle.id

Line 1719: FROM okl_k_lines kle_fee,

1715: cleb_fee.start_date,
1716: cleb_fee.end_date,
1717: cim_fee.id cim_fee_id,
1718: cim_fee.object1_id1
1719: FROM okl_k_lines kle_fee,
1720: okc_k_lines_b cleb_fee,
1721: okc_k_items cim_fee
1722: WHERE cleb_fee.id = p_fee_cle_id
1723: AND kle_fee.id = cleb_fee.id

Line 1748: okl_k_lines kle_cov_asset,

1744: SELECT cleb_cov_asset.id cleb_cov_asset_id,
1745: NVL(kle_cov_asset.capital_amount,kle_cov_asset.amount) amount,
1746: cim_cov_asset.id cim_cov_asset_id
1747: FROM okc_k_lines_b cleb_cov_asset,
1748: okl_k_lines kle_cov_asset,
1749: okc_k_items cim_cov_asset
1750: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1751: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1752: AND kle_cov_asset.id = cleb_cov_asset.id

Line 1786: okl_k_lines kle

1782: CURSOR check_fee_csr(p_chr_id IN NUMBER,
1783: p_fee_type IN VARCHAR2 ) IS
1784: SELECT cle.id
1785: FROM okc_k_lines_b cle,
1786: okl_k_lines kle
1787: WHERE cle.id = kle.id
1788: AND cle.dnz_chr_id = p_chr_id
1789: AND kle.fee_purpose_code = 'SALESTAX'
1790: AND kle.fee_type = p_fee_type

Line 2284: okl_k_lines kle

2280: CURSOR l_fee_csr (p_chr_id IN NUMBER) IS
2281: SELECT cle.id,
2282: kle.fee_type
2283: FROM okc_k_lines_b cle,
2284: okl_k_lines kle
2285: WHERE cle.id = kle.id
2286: AND cle.dnz_chr_id = p_chr_id
2287: AND cle.chr_id = p_chr_id
2288: AND kle.fee_purpose_code = 'SALESTAX'

Line 2536: OKL_K_LINES KLE

2532: -- Bug# 6512668: Exclude fee line in Abandoned status
2533: CURSOR check_fee_csr ( l_fee_type IN VARCHAR2 ) IS
2534: SELECT cle.id
2535: FROM OKC_K_LINES_b cle,
2536: OKL_K_LINES KLE
2537: WHERE cle.id = kle.id
2538: AND cle.dnz_chr_id = p_contract_id
2539: AND kle.fee_purpose_code = 'SALESTAX'
2540: AND kle.fee_type = l_fee_type

Line 4452: okl_k_lines kle

4448: CURSOR check_st_fee_csr(p_chr_id IN NUMBER,
4449: p_fee_type IN VARCHAR2) IS
4450: SELECT cle.id
4451: FROM okc_k_lines_b cle,
4452: okl_k_lines kle
4453: WHERE cle.id = kle.id
4454: AND cle.dnz_chr_id = p_chr_id
4455: AND kle.fee_purpose_code = 'SALESTAX'
4456: AND kle.fee_type = NVL(p_fee_type,kle.fee_type)

Line 4461: l_fee_type_to_delete OKL_K_LINES.fee_type%TYPE;

4457: AND cle.sts_code <> 'ABANDONED';
4458:
4459: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
4460: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
4461: l_fee_type_to_delete OKL_K_LINES.fee_type%TYPE;
4462:
4463: BEGIN
4464: IF (G_DEBUG_ENABLED = 'Y') THEN
4465: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 5397: ,okl_k_lines KLE

5393:
5394: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
5395: SELECT COUNT(KLE.id) new_asset_cnt
5396: FROM okc_k_lines_b CLEB
5397: ,okl_k_lines KLE
5398: WHERE CLEB.id = KLE.id
5399: AND CLEB.dnz_chr_id = p_chr_id
5400: AND CLEB.chr_id = p_chr_id
5401: AND CLEB.LSE_ID = 33 --for asset line

Line 6131: okl_k_lines kle,

6127: --decode(kle.fee_type,'CAPITALIZED',kle.capital_amount,kle.amount) amount
6128: FROM
6129: okc_k_lines_b cleb,
6130: okc_k_lines_tl clet,
6131: okl_k_lines kle,
6132: okc_line_styles_v sty,
6133: okc_statuses_v sts
6134: WHERE cleb.lse_id = sty.id
6135: AND cleb.sts_code = sts.code

Line 6144: l_fee_amount okl_k_lines.amount%TYPE;

6140: AND cleb.id = clet.id
6141: AND clet.LANGUAGE = USERENV('LANG')
6142: AND kle.id = cleb.id;
6143: l_st_fee_rec st_fee_csr%ROWTYPE;
6144: l_fee_amount okl_k_lines.amount%TYPE;
6145:
6146: CURSOR st_fee_link_asset_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS
6147: SELECT cleb.id,
6148: nvl(kle.amount,0) amount,

Line 6151: okl_k_lines kle,

6147: SELECT cleb.id,
6148: nvl(kle.amount,0) amount,
6149: nvl(kle.capital_amount,0) capital_amount
6150: FROM okc_k_lines_b cleb,
6151: okl_k_lines kle,
6152: okc_line_styles_b sty
6153: WHERE cle_id = p_cleId
6154: AND cleb.id = kle.id
6155: AND cleb.lse_id = sty.id

Line 6185: --CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE, p_fee_type OKL_K_LINES.FEE_TYPE%TYPE) IS

6181: AND lty_code = 'FREE_FORM1'
6182: AND cle.sts_code = sts.code
6183: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
6184:
6185: --CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE, p_fee_type OKL_K_LINES.FEE_TYPE%TYPE) IS
6186: CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE) IS
6187: SELECT item.object1_id1,cleb.id,cleb.cle_id,
6188: clet_asset.name,
6189: kle.amount,

Line 6193: okl_k_lines kle,

6189: kle.amount,
6190: kle.fee_type
6191: FROM okc_k_lines_b fee_line,
6192: okc_k_lines_b cleb,
6193: okl_k_lines kle,
6194: okc_k_items item,
6195: okc_k_lines_tl clet_asset,
6196: okc_line_styles_b sty
6197: WHERE fee_line.id = kle.id

Line 6236: okl_k_lines kle,

6232: -- R12B Authoring OA Migration
6233: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6234: SELECT COUNT(cleb.id)
6235: FROM okc_k_lines_b cleb,
6236: okl_k_lines kle,
6237: okc_line_styles_b sty,
6238: okc_statuses_b sts
6239: WHERE cleb.lse_id = sty.id
6240: AND sty.lty_code = 'FEE'

Line 6277: ,okl_k_lines KLE

6273:
6274: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
6275: SELECT COUNT(KLE.id) new_asset_cnt
6276: FROM okc_k_lines_b CLEB
6277: ,okl_k_lines KLE
6278: WHERE CLEB.id = KLE.id
6279: AND CLEB.dnz_chr_id = p_chr_id
6280: AND CLEB.chr_id = p_chr_id
6281: AND CLEB.LSE_ID = 33 --for asset line

Line 6290: FROM okl_k_lines kle_top

6286: -- New cursor to check if the asset is a released asset
6287: -- at the asset line level.
6288: CURSOR l_chk_rel_line_csr (p_kle_id IN OKC_K_LINES_V.ID%TYPE) IS
6289: SELECT NVL(kle_top.re_lease_yn,'N') release_flag
6290: FROM okl_k_lines kle_top
6291: WHERE kle_top.id = p_kle_id;
6292: -- Bug# 15992711 : End of Modifications
6293:
6294: l_release_asset_yn varchar2(1);

Line 7021: okl_k_lines kle,

7017: lsev.name line_type,
7018: --Bug# 12807203
7019: kle.fee_type
7020: FROM okc_k_lines_v clev,
7021: okl_k_lines kle,
7022: okc_statuses_b okcsts,
7023: okc_line_styles_v lsev
7024: WHERE clev.dnz_chr_id = p_chr_id
7025: AND clev.chr_id = p_chr_id

Line 7037: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS

7033:
7034: /* Cursor to get the financed fee sub-lines (applied to assets) for a
7035: given contract. */
7036: CURSOR l_fn_sub_ln_fee_csr ( p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
7037: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
7038: SELECT kle.id,
7039: kle.amount,
7040: cleb.end_date,
7041: cleb.start_date

Line 7043: okl_k_lines kle,

7039: kle.amount,
7040: cleb.end_date,
7041: cleb.start_date
7042: FROM okc_k_lines_b cleb,
7043: okl_k_lines kle,
7044: okc_statuses_b okcsts
7045: WHERE cleb.dnz_chr_id = p_chr_id
7046: AND kle.id = cleb.id
7047: AND cleb.cle_id = p_fee_line_id

Line 7054: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS

7050:
7051: /* Cursor to get the financed fee top/sub-line payments for a
7052: given contract. */
7053: CURSOR l_fn_fee_pmt_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
7054: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
7055: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
7056: SLL.rule_information3 periods,
7057: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
7058: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),

Line 7080: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS

7076:
7077: /* Cursor to get the financed fee top/sub-line payments HEADER for a
7078: given contract. */
7079: CURSOR l_fn_fee_pmtH_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
7080: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
7081:
7082: SELECT slh.id
7083: FROM okc_rules_b slh,
7084: okc_rule_groups_b rgp,