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_ACTIVATE_ASSET_PVT dependencies on OKC_K_LINES_B

Line 1661: okc_k_lines_b cleb_fa,

1657: l_oec,
1658: l_capital_amount,
1659: l_chr_id
1660: From
1661: okc_k_lines_b cleb_fa,
1662: okc_k_lines_b cleb_fin,
1663: okl_k_lines kle_fin
1664: where
1665: cleb_fa.id = p_fa_cle_id

Line 1662: okc_k_lines_b cleb_fin,

1658: l_capital_amount,
1659: l_chr_id
1660: From
1661: okc_k_lines_b cleb_fa,
1662: okc_k_lines_b cleb_fin,
1663: okl_k_lines kle_fin
1664: where
1665: cleb_fa.id = p_fa_cle_id
1666: and cleb_fin.id = cleb_fa.cle_id

Line 1770: From okc_k_lines_b

1766:
1767: --Cursor to get FA line id of original contract
1768: Cursor orig_fa_cle_csr(fa_cle_id IN NUMBER) is
1769: Select orig_system_id1
1770: From okc_k_lines_b
1771: where id = fa_cle_id;
1772:
1773: --cursor to get Cap fees added during Re-book for the asset
1774: Cursor cap_fee_csr(fa_cle_id in number

Line 1779: OKC_K_LINES_B fee_cle,

1775: ,rbk_chr_id in number) IS
1776: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
1777: From
1778: OKL_K_LINES fee_kle,
1779: OKC_K_LINES_B fee_cle,
1780: OKC_STATUSES_B fee_sts,
1781: OKL_K_LINES cov_ast_kle,
1782: OKC_K_LINES_B cov_ast_cle,
1783: OKC_LINE_STYLES_B cov_ast_lse,

Line 1782: OKC_K_LINES_B cov_ast_cle,

1778: OKL_K_LINES fee_kle,
1779: OKC_K_LINES_B fee_cle,
1780: OKC_STATUSES_B fee_sts,
1781: OKL_K_LINES cov_ast_kle,
1782: OKC_K_LINES_B cov_ast_cle,
1783: OKC_LINE_STYLES_B cov_ast_lse,
1784: OKC_STATUSES_B cov_ast_sts,
1785: OKC_K_ITEMS cov_ast_cim,
1786: OKC_K_LINES_B fa_cle,

Line 1786: OKC_K_LINES_B fa_cle,

1782: OKC_K_LINES_B cov_ast_cle,
1783: OKC_LINE_STYLES_B cov_ast_lse,
1784: OKC_STATUSES_B cov_ast_sts,
1785: OKC_K_ITEMS cov_ast_cim,
1786: OKC_K_LINES_B fa_cle,
1787: OKC_K_LINES_B src_cle
1788: Where fee_kle.id = fee_cle.id
1789: and fee_kle.fee_type = 'CAPITALIZED'
1790: and fee_cle.id = cov_ast_cle.cle_id

Line 1787: OKC_K_LINES_B src_cle

1783: OKC_LINE_STYLES_B cov_ast_lse,
1784: OKC_STATUSES_B cov_ast_sts,
1785: OKC_K_ITEMS cov_ast_cim,
1786: OKC_K_LINES_B fa_cle,
1787: OKC_K_LINES_B src_cle
1788: Where fee_kle.id = fee_cle.id
1789: and fee_kle.fee_type = 'CAPITALIZED'
1790: and fee_cle.id = cov_ast_cle.cle_id
1791: and fee_cle.dnz_chr_id = cov_ast_cle.dnz_chr_id

Line 1916: OKC_K_LINES_B mdl,

1912: CURSOR exp_act_csr (p_kle_id IN NUMBER) IS
1913: SELECT msi.expense_account
1914: FROM MTL_SYSTEM_ITEMS msi,
1915: OKC_K_ITEMS cim,
1916: OKC_K_LINES_B mdl,
1917: OKC_K_LINES_B fal
1918: WHERE cim.object1_id1 = msi.inventory_item_id
1919: AND cim.object1_id2 = to_char(msi.organization_id)
1920: AND cim.jtot_object1_code = 'OKX_SYSITEM'

Line 1917: OKC_K_LINES_B fal

1913: SELECT msi.expense_account
1914: FROM MTL_SYSTEM_ITEMS msi,
1915: OKC_K_ITEMS cim,
1916: OKC_K_LINES_B mdl,
1917: OKC_K_LINES_B fal
1918: WHERE cim.object1_id1 = msi.inventory_item_id
1919: AND cim.object1_id2 = to_char(msi.organization_id)
1920: AND cim.jtot_object1_code = 'OKX_SYSITEM'
1921: AND cim.dnz_chr_id = mdl.dnz_chr_id

Line 4640: from okc_k_lines_b cle,

4636: --Bug# 4899328
4637: Cursor fa_line_csr(p_chrv_id IN Number) is
4638: SELECT cle.id,
4639: cle.cle_id
4640: from okc_k_lines_b cle,
4641: okc_statuses_b sts
4642: where cle.lse_id = G_FA_LINE_LTY_ID
4643: and cle.dnz_chr_id = p_chrv_id
4644: and cle.sts_code = sts.code

Line 4681: TYPE fa_line_id_tbl is table of okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;

4677:
4678: --Bug# 3574232
4679: l_adjust_asset_to_zero varchar2(30);
4680:
4681: TYPE fa_line_id_tbl is table of okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;
4682: l_fa_line_id_tbl fa_line_id_tbl;
4683:
4684: TYPE fin_ast_line_id_tbl is table of okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;
4685: l_fin_ast_line_id_tbl fin_ast_line_id_tbl;

Line 4684: TYPE fin_ast_line_id_tbl is table of okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;

4680:
4681: TYPE fa_line_id_tbl is table of okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;
4682: l_fa_line_id_tbl fa_line_id_tbl;
4683:
4684: TYPE fin_ast_line_id_tbl is table of okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;
4685: l_fin_ast_line_id_tbl fin_ast_line_id_tbl;
4686:
4687: TYPE fin_asst_rec_type IS RECORD (
4688: fa_line_id OKC_K_LINES_B.id%TYPE ,

Line 4688: fa_line_id OKC_K_LINES_B.id%TYPE ,

4684: TYPE fin_ast_line_id_tbl is table of okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;
4685: l_fin_ast_line_id_tbl fin_ast_line_id_tbl;
4686:
4687: TYPE fin_asst_rec_type IS RECORD (
4688: fa_line_id OKC_K_LINES_B.id%TYPE ,
4689: fin_ast_line_id OKC_K_LINES_B.cle_id %TYPE);
4690:
4691: TYPE fin_asst_tbl_type IS TABLE OF fin_asst_rec_type INDEX BY BINARY_INTEGER;
4692: l_fin_asst_tbl fin_asst_tbl_type;

Line 4689: fin_ast_line_id OKC_K_LINES_B.cle_id %TYPE);

4685: l_fin_ast_line_id_tbl fin_ast_line_id_tbl;
4686:
4687: TYPE fin_asst_rec_type IS RECORD (
4688: fa_line_id OKC_K_LINES_B.id%TYPE ,
4689: fin_ast_line_id OKC_K_LINES_B.cle_id %TYPE);
4690:
4691: TYPE fin_asst_tbl_type IS TABLE OF fin_asst_rec_type INDEX BY BINARY_INTEGER;
4692: l_fin_asst_tbl fin_asst_tbl_type;
4693: l_counter NUMBER;

Line 5083: OKC_K_LINES_B fa_cle,

5079: cle.name
5080: FROM OKC_K_LINES_V cle,
5081: OKC_LINE_STYLES_B lse,
5082: OKL_K_LINES kle,
5083: OKC_K_LINES_B fa_cle,
5084: OKC_LINE_STYLES_B fa_cle_lse
5085: WHERE kle.id = cle.id
5086: AND cle.chr_id = p_chr_id
5087: AND cle.dnz_chr_id = p_chr_id

Line 5149: OKC_K_LINES_B cle,

5145: --akrangan bug# 5362977 end
5146: --Bug# 6373605 start
5147: OKL_TRX_ASSETS tas,
5148: --Bug# 6373605 end
5149: OKC_K_LINES_B cle,
5150: OKC_LINE_STYLES_B lse
5151: WHERE txl.kle_id = cle.id
5152: --Bug# 6373605 start
5153: AND tas.id = txl.tas_id

Line 5208: OKC_K_LINES_B cle,

5204: OKL_TXL_ASSETS_B txl,
5205: --Bug# 6373605 start
5206: OKL_TRX_ASSETS tas,
5207: --Bug# 6373605 end
5208: OKC_K_LINES_B cle,
5209: OKC_LINE_STYLES_B lse
5210: WHERE txd.tal_id = txl.id
5211: --Bug# 6373605 start
5212: AND tas.id = txl.tas_id

Line 5265: from OKC_K_LINES_B cle,

5261: p_asset_id1 IN VARCHAR2,
5262: p_asset_id2 IN VARCHAR2,
5263: p_effective_date IN DATE) IS
5264: Select '!'
5265: from OKC_K_LINES_B cle,
5266: OKC_STATUSES_B sts,
5267: OKC_K_ITEMS cim
5268: Where cle.sts_code = sts.CODE
5269: --Bug# 2942543 : effectivity should be checked by keeping start and end date as inclusive

Line 5302: okc_k_lines_b fa_cle,

5298: fa_cle.id new_fa_cle_id,
5299: clev.chr_id orig_chr_id
5300: From okc_k_lines_v clev,
5301: okc_line_styles_b lse,
5302: okc_k_lines_b fa_cle,
5303: okc_line_styles_b fa_lse,
5304: okc_k_headers_b chr
5305: where clev.chr_id = chr.orig_system_id1
5306: and clev.dnz_chr_id = chr.orig_system_id1

Line 5323: l_new_fin_cle_id OKC_K_LINES_B.ID%TYPE;

5319: and fa_cle.dnz_chr_id = chr.orig_system_id1
5320: and fa_cle.lse_id = fa_lse.id
5321: and fa_lse.lty_code = G_FA_LINE_LTY_CODE;
5322:
5323: l_new_fin_cle_id OKC_K_LINES_B.ID%TYPE;
5324: l_new_fa_cle_id OKC_K_LINES_B.ID%TYPE;
5325: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
5326: lx_cimv_rec cimv_rec_type;
5327: lx_cimv_ib_tbl cimv_tbl_type;

Line 5324: l_new_fa_cle_id OKC_K_LINES_B.ID%TYPE;

5320: and fa_cle.lse_id = fa_lse.id
5321: and fa_lse.lty_code = G_FA_LINE_LTY_CODE;
5322:
5323: l_new_fin_cle_id OKC_K_LINES_B.ID%TYPE;
5324: l_new_fa_cle_id OKC_K_LINES_B.ID%TYPE;
5325: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
5326: lx_cimv_rec cimv_rec_type;
5327: lx_cimv_ib_tbl cimv_tbl_type;
5328:

Line 6368: OKC_K_LINES_B fa_cle,

6364: cle.name
6365: FROM OKC_K_LINES_V cle,
6366: OKC_LINE_STYLES_B lse,
6367: OKL_K_LINES kle,
6368: OKC_K_LINES_B fa_cle,
6369: OKC_LINE_STYLES_B fa_cle_lse
6370: WHERE kle.id = cle.id
6371: AND cle.chr_id = p_chr_id
6372: AND cle.dnz_chr_id = p_chr_id

Line 6424: OKC_K_LINES_B cle,

6420: FROM OKL_TXL_ASSETS_B txl,
6421: --Bug# 6373605 start
6422: OKL_TRX_ASSETS tas,
6423: --Bug# 6373605 end
6424: OKC_K_LINES_B cle,
6425: OKC_LINE_STYLES_B lse
6426: WHERE txl.kle_id = cle.id
6427: AND txl.tal_type = 'CRB'
6428: --Bug# 6373605 start

Line 6479: OKC_K_LINES_B cle,

6475: OKL_TXL_ASSETS_B txl,
6476: --Bug# 6373605 start
6477: OKL_TRX_ASSETS tas,
6478: --Bug# 6373605 end
6479: OKC_K_LINES_B cle,
6480: OKC_LINE_STYLES_B lse
6481: WHERE txd.tal_id = txl.id
6482: --Bug# 6373605 start
6483: AND tas.id = txl.tas_id

Line 6545: from OKC_K_LINES_B cle,

6541: p_asset_id1 IN VARCHAR2,
6542: p_asset_id2 IN VARCHAR2,
6543: p_effective_date IN DATE) IS
6544: Select '!'
6545: from OKC_K_LINES_B cle,
6546: OKC_STATUSES_B sts,
6547: OKC_K_ITEMS cim
6548: Where cle.sts_code = sts.CODE
6549: --Bug# 2942543 : effectivity should be checked by keeping start and end date as inclusive

Line 7472: OKC_K_LINES_B cle,

7468: --Bug# 6373605 end
7469: FROM OKL_TRX_TYPES_TL ttyp,
7470: OKL_TRX_ASSETS trx,
7471: OKL_TXL_ASSETS_B txl,
7472: OKC_K_LINES_B cle,
7473: OKC_LINE_STYLES_B lse,
7474: -- Bug# 3631094
7475: FA_BOOK_CONTROLS fab
7476: WHERE txl.kle_id = cle.id

Line 7552: OKC_K_LINES_B cle,

7548: FROM OKL_TRX_TYPES_TL ttyp,
7549: OKL_TRX_ASSETS trx,
7550: OKL_TXD_ASSETS_B txd,
7551: OKL_TXL_ASSETS_B txl,
7552: OKC_K_LINES_B cle,
7553: OKC_LINE_STYLES_B lse,
7554: -- Bug# 3631094
7555: FA_BOOK_CONTROLS fab
7556: WHERE txd.tal_id = txl.id

Line 7650: from okc_k_lines_b cleb,

7646: cursor l_allast_csr (p_chr_id in number) is
7647: select cleb.id,
7648: --Bug# 3783518
7649: cleb.orig_system_id1
7650: from okc_k_lines_b cleb,
7651: okc_line_styles_b lseb,
7652: okc_statuses_b stsb
7653: where cleb.chr_id = p_chr_id
7654: and cleb.dnz_chr_id = p_chr_id

Line 7660: l_asset_cle_id okc_k_lines_b.ID%TYPE;

7656: and lseb.lty_code = G_FIN_AST_LINE_LTY_CODE
7657: and stsb.code = cleb.sts_code
7658: and stsb.ste_code not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');
7659:
7660: l_asset_cle_id okc_k_lines_b.ID%TYPE;
7661:
7662: l_subsidy_exists varchar2(1) default OKL_API.G_FALSE;
7663: l_total_discount number;
7664: l_cost_adjustment number;

Line 7691: okc_k_lines_b fa_cleb,

7687: okc_k_items fa_cim,
7688: okl_trx_types_tl ttyp,
7689: okl_trx_assets trx,
7690: okl_txl_assets_b txl,
7691: okc_k_lines_b fa_cleb,
7692: okc_line_styles_b fa_lseb,
7693: okc_k_lines_tl ast_clet
7694: where
7695: fab.asset_id = to_number(fa_cim.object1_id1)

Line 7755: OKC_K_LINES_B cle,

7751: CURSOR tas_csr(p_chr_id in number) IS
7752: SELECT trx.id
7753: FROM OKL_TRX_ASSETS trx,
7754: OKL_TXL_ASSETS_B txl,
7755: OKC_K_LINES_B cle,
7756: OKC_LINE_STYLES_B lse
7757: WHERE txl.kle_id = cle.id
7758: AND cle.dnz_chr_id = p_chr_id
7759: AND cle.lse_id = lse.id

Line 7837: FROM okc_k_lines_b cle,

7833:
7834: --Bug# 3783518
7835: CURSOR orig_pdt_csr(p_cle_id IN NUMBER) is
7836: SELECT pdt.reporting_pdt_id
7837: FROM okc_k_lines_b cle,
7838: okl_k_headers khr,
7839: okl_products pdt
7840: WHERE cle.id = p_cle_id
7841: AND khr.id = cle.dnz_chr_id

Line 7873: OKC_K_LINES_B fee_cle,

7869: ,rel_chr_id in number) IS
7870: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
7871: From
7872: OKL_K_LINES fee_kle,
7873: OKC_K_LINES_B fee_cle,
7874: OKC_STATUSES_B fee_sts,
7875: OKL_K_LINES cov_ast_kle,
7876: OKC_K_LINES_B cov_ast_cle,
7877: OKC_LINE_STYLES_B cov_ast_lse,

Line 7876: OKC_K_LINES_B cov_ast_cle,

7872: OKL_K_LINES fee_kle,
7873: OKC_K_LINES_B fee_cle,
7874: OKC_STATUSES_B fee_sts,
7875: OKL_K_LINES cov_ast_kle,
7876: OKC_K_LINES_B cov_ast_cle,
7877: OKC_LINE_STYLES_B cov_ast_lse,
7878: OKC_STATUSES_B cov_ast_sts,
7879: OKC_K_ITEMS cov_ast_cim,
7880: OKC_K_LINES_B fa_cle

Line 7880: OKC_K_LINES_B fa_cle

7876: OKC_K_LINES_B cov_ast_cle,
7877: OKC_LINE_STYLES_B cov_ast_lse,
7878: OKC_STATUSES_B cov_ast_sts,
7879: OKC_K_ITEMS cov_ast_cim,
7880: OKC_K_LINES_B fa_cle
7881: Where fee_kle.id = fee_cle.id
7882: and fee_kle.fee_type = 'CAPITALIZED'
7883: and fee_cle.id = cov_ast_cle.cle_id
7884: and fee_cle.dnz_chr_id = cov_ast_cle.dnz_chr_id

Line 9323: okc_k_lines_b cleb,

9319: trx.creation_date
9320: from okl_trx_types_tl ttyt,
9321: okl_trx_assets trx,
9322: okl_txl_assets_b txl,
9323: okc_k_lines_b cleb,
9324: okc_line_styles_b lseb
9325: where ttyt.id = trx.try_id
9326: and ttyt.language = 'US'
9327: and trx.id = txl.tas_id

Line 9371: okc_k_lines_b cleb,

9367: from fa_additions fa,
9368: fa_books fab,
9369: fa_book_controls fbc,
9370: okc_k_items cim,
9371: okc_k_lines_b cleb,
9372: okc_line_styles_b lseb
9373: where fab.asset_id = fa.asset_id
9374: and fab.transaction_header_id_out is null
9375: and fbc.book_type_code = fab.book_type_code

Line 9615: OKC_K_LINES_B fee_cle,

9611: ,p_chr_id in number) IS
9612: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
9613: From
9614: OKL_K_LINES fee_kle,
9615: OKC_K_LINES_B fee_cle,
9616: OKC_STATUSES_B fee_sts,
9617: OKL_K_LINES cov_ast_kle,
9618: OKC_K_LINES_B cov_ast_cle,
9619: OKC_STATUSES_B cov_ast_sts,

Line 9618: OKC_K_LINES_B cov_ast_cle,

9614: OKL_K_LINES fee_kle,
9615: OKC_K_LINES_B fee_cle,
9616: OKC_STATUSES_B fee_sts,
9617: OKL_K_LINES cov_ast_kle,
9618: OKC_K_LINES_B cov_ast_cle,
9619: OKC_STATUSES_B cov_ast_sts,
9620: OKC_K_ITEMS cov_ast_cim
9621: Where fee_kle.id = fee_cle.id
9622: and fee_kle.fee_type = 'CAPITALIZED'

Line 11129: okc_k_lines_b cleb,

11125: trx.creation_date
11126: from okl_trx_types_tl ttyt,
11127: okl_trx_assets trx,
11128: okl_txl_assets_b txl,
11129: okc_k_lines_b cleb,
11130: okc_line_styles_b lseb
11131: where ttyt.id = trx.try_id
11132: and ttyt.language = 'US'
11133: and trx.id = txl.tas_id

Line 11181: from okc_k_lines_b cleb_fin,

11177: l_rep_pdt_book fa_books.book_type_code%TYPE;
11178:
11179: cursor l_capital_cost_csr(p_fin_cle_id in number) IS
11180: select kle_fin.capital_amount
11181: from okc_k_lines_b cleb_fin,
11182: okl_k_lines kle_fin
11183: where cleb_fin.id = p_fin_cle_id
11184: and kle_fin.id = cleb_fin.id;
11185: