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 OKL_TXD_ASSETS_B

Line 942: -- OKL_TXD_ASSETS_B

938: -- p_sla_source_try_id IN Number,
939: -- OKL_TRX_ASSETS.try_id (transaction type id)
940: -- p_sla_source_line_id IN Number,
941: -- ID of line table (OKL_TXL_ASSETS_B or
942: -- OKL_TXD_ASSETS_B
943: -- p_sla_source_line_table IN Varchar2,
944: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B
945: -- p_sla_source_chr_id IN Number,
946: -- Contract id of the contract on which

Line 944: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B

940: -- p_sla_source_line_id IN Number,
941: -- ID of line table (OKL_TXL_ASSETS_B or
942: -- OKL_TXD_ASSETS_B
943: -- p_sla_source_line_table IN Varchar2,
944: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B
945: -- p_sla_source_chr_id IN Number,
946: -- Contract id of the contract on which
947: -- source transaction happened
948: -- p_sla_source_kle_id IN Number,

Line 3272: from okl_txd_assets_b txdb

3268: -- Cursor to fetch txd transaction for a tax book
3269: Cursor l_txd_for_book_csr (p_book_type_code in varchar2,
3270: p_tal_id in number) is
3271: select id
3272: from okl_txd_assets_b txdb
3273: where tal_id = p_tal_id
3274: and tax_book = p_book_type_code;
3275:
3276: l_txd_for_book_rec l_txd_for_book_csr%ROWTYPE;

Line 3621: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',

3617: p_sla_source_header_id => l_tas_id,
3618: p_sla_source_header_table => 'OKL_TRX_ASSETS',
3619: p_sla_source_try_id => l_try_id,
3620: p_sla_source_line_id => okl_tadv_rec.asd_id,
3621: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',
3622: p_sla_source_chr_id => p_chrv_id,
3623: p_sla_source_kle_id => p_fin_ast_line_id,
3624: p_sla_asset_chr_id => p_sla_asset_chr_id,
3625: --Bug# 6373605--SLA populate sources

Line 3998: 'OKL_TXD_ASSETS_B';

3994: 'OKL_TXL_ASSETS_B';
3995: l_sla_source_line_id := l_talv_rec.id;
3996: Else
3997: l_sla_source_line_table :=
3998: 'OKL_TXD_ASSETS_B';
3999: l_sla_source_line_id :=
4000: l_txd_for_book_rec.id;
4001: End If;
4002: Close l_txd_for_book_csr;

Line 4276: 'OKL_TXD_ASSETS_B';

4272: 'OKL_TXL_ASSETS_B';
4273: l_sla_source_line_id := l_talv_rec.id;
4274: Else
4275: l_sla_source_line_table :=
4276: 'OKL_TXD_ASSETS_B';
4277: l_sla_source_line_id :=
4278: l_txd_for_book_rec.id;
4279: End If;
4280: Close l_txd_for_book_csr;

Line 4366: 'OKL_TXD_ASSETS_B';

4362: 'OKL_TXL_ASSETS_B';
4363: l_sla_source_line_id := l_talv_rec.id;
4364: Else
4365: l_sla_source_line_table :=
4366: 'OKL_TXD_ASSETS_B';
4367: l_sla_source_line_id :=
4368: l_txd_for_book_rec.id;
4369: End If;
4370: Close l_txd_for_book_csr;

Line 5170: 'OKL_TXD_ASSETS_B' sla_source_line_table,

5166: -- akrangan Bug# 5362977 end
5167: --Bug# 6373605 start
5168: txd.id sla_source_line_id,
5169: txl.tas_id sla_source_header_id,
5170: 'OKL_TXD_ASSETS_B' sla_source_line_table,
5171: tas.try_id sla_source_try_id,
5172: --Bug# 6373605 end
5173:
5174: --sechawla bug 8370324

Line 5178: FROM OKL_TXD_ASSETS_B txd,

5174: --sechawla bug 8370324
5175: cle.start_date line_start_date,
5176: --Bug# 8652738
5177: NULL asset_key_id
5178: FROM OKL_TXD_ASSETS_B txd,
5179: OKL_TXL_ASSETS_B txl,
5180: --Bug# 6373605 start
5181: OKL_TRX_ASSETS tas,
5182: --Bug# 6373605 end

Line 6401: 'OKL_TXD_ASSETS_B' sla_source_line_table,

6397: null tal_id,
6398: --Bug# 6373605 start
6399: txd.id sla_source_line_id,
6400: txl.tas_id sla_source_header_id,
6401: 'OKL_TXD_ASSETS_B' sla_source_line_table,
6402: tas.try_id sla_source_try_id,
6403: cle.cle_id sla_source_kle_id,
6404: --Bug# 6373605 end
6405: --sechawla : Bug# 8370324

Line 6407: FROM OKL_TXD_ASSETS_B txd,

6403: cle.cle_id sla_source_kle_id,
6404: --Bug# 6373605 end
6405: --sechawla : Bug# 8370324
6406: cle.start_date line_start_date
6407: FROM OKL_TXD_ASSETS_B txd,
6408: OKL_TXL_ASSETS_B txl,
6409: --Bug# 6373605 start
6410: OKL_TRX_ASSETS tas,
6411: --Bug# 6373605 end

Line 7269: 'OKL_TXD_ASSETS_B' sla_source_line_table,

7265: txl.percent_salvage_value corp_pct_salvage_value,
7266: --bug# 6373605 start
7267: trx.id sla_source_header_id,
7268: txd.id sla_source_line_id,
7269: 'OKL_TXD_ASSETS_B' sla_source_line_table,
7270: trx.try_id sla_source_try_id,
7271: cle.cle_id sla_source_kle_id
7272: --Bug# 6373605 end
7273: FROM OKL_TRX_TYPES_TL ttyp,

Line 7275: OKL_TXD_ASSETS_B txd,

7271: cle.cle_id sla_source_kle_id
7272: --Bug# 6373605 end
7273: FROM OKL_TRX_TYPES_TL ttyp,
7274: OKL_TRX_ASSETS trx,
7275: OKL_TXD_ASSETS_B txd,
7276: OKL_TXL_ASSETS_B txl,
7277: OKC_K_LINES_B cle,
7278: OKC_LINE_STYLES_B lse,
7279: -- Bug# 3631094

Line 7454: from okl_txd_Assets_b

7450: Cursor l_txd_from_book_type_csr (p_book_type_code in varchar2,
7451: p_tal_id in number) is
7452: select id sla_source_line_id,
7453: tax_book
7454: from okl_txd_Assets_b
7455: where tal_id = p_tal_id
7456: and tax_book = p_book_type_code;
7457:
7458: l_txd_from_book_type_rec l_txd_from_book_type_csr%ROWTYPE;

Line 8905: 'OKL_TXD_ASSETS_B';

8901: Else
8902: l_sla_source_line_id :=
8903: l_txd_from_book_type_rec.sla_source_line_id;
8904: l_sla_source_line_table :=
8905: 'OKL_TXD_ASSETS_B';
8906: End If;
8907: Close l_txd_from_book_type_Csr;
8908: End If;
8909:

Line 9209: from okl_txd_Assets_b txd,

9205: txd.life_in_months_tax,
9206: txd.deprn_rate_tax,
9207: fcbd.prorate_convention_code,
9208: txd.cost
9209: from okl_txd_Assets_b txd,
9210: fa_book_controls fbc,
9211: fa_category_book_defaults fcbd
9212: where fcbd.category_id = p_category_id
9213: and fcbd.book_type_code = txd.tax_book

Line 9232: from okl_txd_Assets_b txd,

9228: txd.life_in_months_tax,
9229: txd.deprn_rate_tax,
9230: fcbd.prorate_convention_code,
9231: txd.cost
9232: from okl_txd_Assets_b txd,
9233: fa_book_controls fbc,
9234: fa_category_book_defaults fcbd
9235: where fcbd.category_id = p_category_id
9236: and fcbd.book_type_code = txd.tax_book

Line 10899: from okl_txd_Assets_b txd

10895:
10896: cursor l_tax_book_csr(p_tal_id in number) is
10897: select txd.id,
10898: txd.tax_book
10899: from okl_txd_Assets_b txd
10900: where txd.tal_id = p_tal_id;
10901:
10902: l_rep_pdt_book fa_books.book_type_code%TYPE;
10903: