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.

[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKL_TXD_ASSETS_B

Line 938: -- OKL_TXD_ASSETS_B

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

Line 940: -- OKL_TXL_ASSETS_B or OKL_TXD_ASSETS_B

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

Line 3263: from okl_txd_assets_b txdb

3259: -- Cursor to fetch txd transaction for a tax book
3260: Cursor l_txd_for_book_csr (p_book_type_code in varchar2,
3261: p_tal_id in number) is
3262: select id
3263: from okl_txd_assets_b txdb
3264: where tal_id = p_tal_id
3265: and tax_book = p_book_type_code;
3266:
3267: l_txd_for_book_rec l_txd_for_book_csr%ROWTYPE;

Line 3612: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',

3608: p_sla_source_header_id => l_tas_id,
3609: p_sla_source_header_table => 'OKL_TRX_ASSETS',
3610: p_sla_source_try_id => l_try_id,
3611: p_sla_source_line_id => okl_tadv_rec.asd_id,
3612: p_sla_source_line_table => 'OKL_TXD_ASSETS_B',
3613: p_sla_source_chr_id => p_chrv_id,
3614: p_sla_source_kle_id => p_fin_ast_line_id,
3615: p_sla_asset_chr_id => p_sla_asset_chr_id,
3616: --Bug# 6373605--SLA populate sources

Line 3989: 'OKL_TXD_ASSETS_B';

3985: 'OKL_TXL_ASSETS_B';
3986: l_sla_source_line_id := l_talv_rec.id;
3987: Else
3988: l_sla_source_line_table :=
3989: 'OKL_TXD_ASSETS_B';
3990: l_sla_source_line_id :=
3991: l_txd_for_book_rec.id;
3992: End If;
3993: Close l_txd_for_book_csr;

Line 4267: 'OKL_TXD_ASSETS_B';

4263: 'OKL_TXL_ASSETS_B';
4264: l_sla_source_line_id := l_talv_rec.id;
4265: Else
4266: l_sla_source_line_table :=
4267: 'OKL_TXD_ASSETS_B';
4268: l_sla_source_line_id :=
4269: l_txd_for_book_rec.id;
4270: End If;
4271: Close l_txd_for_book_csr;

Line 4357: 'OKL_TXD_ASSETS_B';

4353: 'OKL_TXL_ASSETS_B';
4354: l_sla_source_line_id := l_talv_rec.id;
4355: Else
4356: l_sla_source_line_table :=
4357: 'OKL_TXD_ASSETS_B';
4358: l_sla_source_line_id :=
4359: l_txd_for_book_rec.id;
4360: End If;
4361: Close l_txd_for_book_csr;

Line 5200: 'OKL_TXD_ASSETS_B' sla_source_line_table,

5196: -- akrangan Bug# 5362977 end
5197: --Bug# 6373605 start
5198: txd.id sla_source_line_id,
5199: txl.tas_id sla_source_header_id,
5200: 'OKL_TXD_ASSETS_B' sla_source_line_table,
5201: tas.try_id sla_source_try_id
5202: --Bug# 6373605 end
5203: FROM OKL_TXD_ASSETS_B txd,
5204: OKL_TXL_ASSETS_B txl,

Line 5203: FROM OKL_TXD_ASSETS_B txd,

5199: txl.tas_id sla_source_header_id,
5200: 'OKL_TXD_ASSETS_B' sla_source_line_table,
5201: tas.try_id sla_source_try_id
5202: --Bug# 6373605 end
5203: FROM OKL_TXD_ASSETS_B txd,
5204: OKL_TXL_ASSETS_B txl,
5205: --Bug# 6373605 start
5206: OKL_TRX_ASSETS tas,
5207: --Bug# 6373605 end

Line 6470: 'OKL_TXD_ASSETS_B' sla_source_line_table,

6466: null tal_id,
6467: --Bug# 6373605 start
6468: txd.id sla_source_line_id,
6469: txl.tas_id sla_source_header_id,
6470: 'OKL_TXD_ASSETS_B' sla_source_line_table,
6471: tas.try_id sla_source_try_id,
6472: cle.cle_id sla_source_kle_id
6473: --Bug# 6373605 end
6474: FROM OKL_TXD_ASSETS_B txd,

Line 6474: FROM OKL_TXD_ASSETS_B txd,

6470: 'OKL_TXD_ASSETS_B' sla_source_line_table,
6471: tas.try_id sla_source_try_id,
6472: cle.cle_id sla_source_kle_id
6473: --Bug# 6373605 end
6474: FROM OKL_TXD_ASSETS_B txd,
6475: OKL_TXL_ASSETS_B txl,
6476: --Bug# 6373605 start
6477: OKL_TRX_ASSETS tas,
6478: --Bug# 6373605 end

Line 7544: 'OKL_TXD_ASSETS_B' sla_source_line_table,

7540: txl.percent_salvage_value corp_pct_salvage_value,
7541: --bug# 6373605 start
7542: trx.id sla_source_header_id,
7543: txd.id sla_source_line_id,
7544: 'OKL_TXD_ASSETS_B' sla_source_line_table,
7545: trx.try_id sla_source_try_id,
7546: cle.cle_id sla_source_kle_id
7547: --Bug# 6373605 end
7548: FROM OKL_TRX_TYPES_TL ttyp,

Line 7550: OKL_TXD_ASSETS_B txd,

7546: cle.cle_id sla_source_kle_id
7547: --Bug# 6373605 end
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

Line 7729: from okl_txd_Assets_b

7725: Cursor l_txd_from_book_type_csr (p_book_type_code in varchar2,
7726: p_tal_id in number) is
7727: select id sla_source_line_id,
7728: tax_book
7729: from okl_txd_Assets_b
7730: where tal_id = p_tal_id
7731: and tax_book = p_book_type_code;
7732:
7733: l_txd_from_book_type_rec l_txd_from_book_type_csr%ROWTYPE;

Line 9180: 'OKL_TXD_ASSETS_B';

9176: Else
9177: l_sla_source_line_id :=
9178: l_txd_from_book_type_rec.sla_source_line_id;
9179: l_sla_source_line_table :=
9180: 'OKL_TXD_ASSETS_B';
9181: End If;
9182: Close l_txd_from_book_type_Csr;
9183: End If;
9184:

Line 9484: from okl_txd_Assets_b txd,

9480: txd.life_in_months_tax,
9481: txd.deprn_rate_tax,
9482: fcbd.prorate_convention_code,
9483: txd.cost
9484: from okl_txd_Assets_b txd,
9485: fa_book_controls fbc,
9486: fa_category_book_defaults fcbd
9487: where fcbd.category_id = p_category_id
9488: and fcbd.book_type_code = txd.tax_book

Line 9507: from okl_txd_Assets_b txd,

9503: txd.life_in_months_tax,
9504: txd.deprn_rate_tax,
9505: fcbd.prorate_convention_code,
9506: txd.cost
9507: from okl_txd_Assets_b txd,
9508: fa_book_controls fbc,
9509: fa_category_book_defaults fcbd
9510: where fcbd.category_id = p_category_id
9511: and fcbd.book_type_code = txd.tax_book

Line 11174: from okl_txd_Assets_b txd

11170:
11171: cursor l_tax_book_csr(p_tal_id in number) is
11172: select txd.id,
11173: txd.tax_book
11174: from okl_txd_Assets_b txd
11175: where txd.tal_id = p_tal_id;
11176:
11177: l_rep_pdt_book fa_books.book_type_code%TYPE;
11178: