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

Line 198: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views

194: -- This cursor picks up the amortization ,evergreen depreciation and salvage value writedown transactions to be
195: -- processed in Fixed Assets. AMT - amortization, AED - evergreen, FSC - Salvage value writedown.
196: CURSOR l_distinctasset_csr(cp_date IN DATE, p_org_id NUMBER) IS
197: SELECT DISTINCT l.asset_number, l.kle_id, b.authoring_org_id
198: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views
199: ,okc_k_headers_all_b b /* Bug 6459571 */
200: WHERE h.id = l.tas_id
201: AND h.tsu_code in('ENTERED','ERROR') -- SMODUGA 07-FEB-05 3578894 : process trx in entered and error status only
202: AND h.date_trans_occurred <= cp_date

Line 252: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views

248: --,l.currency_code func_currency_code -- SECHAWLA 29-JUL-05 4456005 : added
249: --,l.DNZ_KHR_ID -- SECHAWLA 29-JUL-05 4456005 : added
250: -- SGORANTL 22-MAR-06 5097643: changes made by kbbhavsa for bug 4717511 has been reversed
251: ,h.try_id --akrangan added for sla populate sources cr
252: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views
253: WHERE h.id = l.tas_id
254: AND l.id = d.tal_id(+)
255: AND FL.LOOKUP_CODE = h.TAS_TYPE AND FL.LOOKUP_TYPE = 'OKL_TRANS_HEADER_TYPE'
256: AND decode(d.tax_book,NULL, l.CORPORATE_BOOK,d.tax_book ) = fbc.book_type_code

Line 280: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views

276: --,l.DNZ_KHR_ID -- SECHAWLA 29-JUL-05 4456005 : added
277: -- SGORANTL 22-MAR-06 5097643: changes made by kbbhavsa for bug 4717511 has been reversed
278: ,h.try_id --akrangan added for sla populate sources cr
279: ,l.id line_id --akrangan added for sla populate sources cr
280: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views
281: WHERE h.id = l.tas_id
282: AND l.id = d.tal_id(+)
283: AND FL.LOOKUP_CODE = h.TAS_TYPE AND FL.LOOKUP_TYPE = 'OKL_TRANS_HEADER_TYPE'
284: AND decode(d.tax_book,NULL, l.CORPORATE_BOOK,d.tax_book ) = fbc.book_type_code

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

679: l_fxhv_rec.khr_id := l_chr_id;
680: l_fxhv_rec.try_id := l_assettrx_rec.try_id;
681: --line record
682: l_fxlv_rec.source_id := l_assettrx_rec.line_id;
683: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';
684: l_fxlv_rec.asset_id := l_assettrx_rec.dnz_asset_id;
685: l_fxlv_rec.kle_id := l_assettrx_rec.kle_id;
686: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
687: l_fxlv_rec.asset_book_type_name := l_assettrx_rec.asset_book;

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

794: l_fxhv_rec.khr_id := l_chr_id;
795: l_fxhv_rec.try_id := l_assettrx_rec.try_id;
796: --line record
797: l_fxlv_rec.source_id := l_assettrx_rec.line_id;
798: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';
799: l_fxlv_rec.asset_id := l_assettrx_rec.dnz_asset_id;
800: l_fxlv_rec.kle_id := l_assettrx_rec.kle_id;
801: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
802: l_fxlv_rec.asset_book_type_name := l_assettrx_rec.asset_book;

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

1022: l_fxhv_rec.khr_id := l_chr_id;
1023: l_fxhv_rec.try_id := l_assettrx_rec.try_id;
1024: --line record
1025: l_fxlv_rec.source_id := l_assettrx_rec.line_id;
1026: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';
1027: l_fxlv_rec.asset_id := l_assettrx_rec.dnz_asset_id;
1028: l_fxlv_rec.kle_id := l_assettrx_rec.kle_id;
1029: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
1030: l_fxlv_rec.asset_book_type_name := l_assettrx_rec.asset_book;

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

1135: l_fxhv_rec.khr_id := l_chr_id;
1136: l_fxhv_rec.try_id := l_assettrx_rec.try_id;
1137: --line record
1138: l_fxlv_rec.source_id := l_assettrx_rec.line_id;
1139: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';
1140: l_fxlv_rec.asset_id := l_assettrx_rec.dnz_asset_id;
1141: l_fxlv_rec.kle_id := l_assettrx_rec.kle_id;
1142: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
1143: l_fxlv_rec.asset_book_type_name := l_assettrx_rec.asset_book;

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

1596: l_fxhv_rec.khr_id := l_chr_id;
1597: l_fxhv_rec.try_id := l_assetsvtrx_rec.try_id;
1598: --line record
1599: l_fxlv_rec.source_id := l_assetsvtrx_rec.line_id;
1600: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';
1601: l_fxlv_rec.asset_id := l_assetsvtrx_rec.dnz_asset_id;
1602: l_fxlv_rec.kle_id := l_assetsvtrx_rec.kle_id;
1603: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
1604: l_fxlv_rec.asset_book_type_name := l_books_tbl(i);