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_AM_ASSET_DISPOSE_PVT dependencies on OKL_TXL_ASSETS_B

Line 1866: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l

1862: --Bug# 9838432: Added parameter cp_kle_id
1863: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2, cp_kle_id IN NUMBER) IS
1864: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
1865: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
1866: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
1867: WHERE h.id = l.tas_id
1868: AND h.date_trans_occurred <= cp_trx_date
1869: AND h.tas_type in ('AMT','AUD','AUS')
1870: AND l.asset_number = cp_asset_number

Line 3276: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';

3272: l_fxhv_rec.khr_id := lx_tlpv_rec.dnz_khr_id;
3273: l_fxhv_rec.try_id := lx_thpv_rec.try_id;
3274: -- line record
3275: l_fxlv_rec.source_id := lx_tlpv_rec.id;
3276: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';
3277: l_fxlv_rec.kle_id := p_financial_asset_id;
3278: l_fxlv_rec.asset_id := lx_tlpv_rec.dnz_asset_id;
3279: l_fxlv_rec.fa_transaction_id := g_trans_id_tbl(i);
3280: l_fxlv_rec.asset_book_type_name := lx_tlpv_rec.corporate_book;

Line 3687: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l

3683: --Bug# 9838432: Added parameter cp_kle_id
3684: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2, cp_kle_id IN NUMBER) IS
3685: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
3686: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
3687: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
3688: WHERE h.id = l.tas_id
3689: AND h.date_trans_occurred <= cp_trx_date
3690: AND h.tas_type in ('AMT','AUD','AUS')
3691: AND l.asset_number = cp_asset_number

Line 4989: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';

4985: l_fxhv_rec.khr_id := lx_tlpv_rec.dnz_khr_id;
4986: l_fxhv_rec.try_id := lx_thpv_rec.try_id;
4987: -- line record
4988: l_fxlv_rec.source_id := lx_tlpv_rec.id;
4989: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';
4990: l_fxlv_rec.kle_id := lx_tlpv_rec.kle_id;
4991: l_fxlv_rec.asset_id := lx_tlpv_rec.dnz_asset_id;
4992: l_fxlv_rec.fa_transaction_id := g_trans_id_tbl(i);
4993: l_fxlv_rec.asset_book_type_name := lx_tlpv_rec.corporate_book;