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.FA_ASSET_VAL_PVT dependencies on FA_DEPRN_SUMMARY

Line 2628: FROM fa_deprn_summary

2624:
2625: if (p_mode = 'ABSOLUTE') then
2626: SELECT count(*)
2627: INTO l_count
2628: FROM fa_deprn_summary
2629: WHERE book_type_code = p_book
2630: AND asset_id = p_asset_id
2631: AND deprn_source_code = 'BOOKS'
2632: AND period_counter = l_last_pc;

Line 5559: (select 'x' from fa_deprn_summary

5555:
5556: CURSOR c_asset_with_reserve is
5557: select count(1) from dual
5558: where exists
5559: (select 'x' from fa_deprn_summary
5560: where book_type_code = p_asset_hdr_rec.book_type_code
5561: and asset_id = p_asset_hdr_rec.asset_id
5562: and deprn_source_code = 'BOOKS'
5563: and deprn_reserve > 0);

Line 6405: AND NOT EXISTS (SELECT 1 FROM FA_DEPRN_SUMMARY FADS

6401: AND NOT EXISTS (SELECT 1 FROM FA_BOOKS FABK1
6402: WHERE FABK1.ASSET_ID = p_asset_id
6403: AND FABK1.BOOK_TYPE_CODE = p_book_type_code
6404: AND FABK1.DEPRECIATE_FLAG = 'YES')
6405: AND NOT EXISTS (SELECT 1 FROM FA_DEPRN_SUMMARY FADS
6406: WHERE FADS.ASSET_ID = p_asset_id
6407: AND FADS.BOOK_TYPE_CODE = p_book_type_code
6408: AND FADS.DEPRN_SOURCE_CODE = 'BOOKS'
6409: AND FADS.DEPRN_RESERVE > 0 );

Line 6509: l_deprn_reserve fa_deprn_summary.deprn_reserve%type;

6505: l_corp_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6506: l_corp_method_code fa_methods.method_code%type;
6507:
6508: /* Added for ENH 12600386 Start */
6509: l_deprn_reserve fa_deprn_summary.deprn_reserve%type;
6510: l_ytd_deprn fa_deprn_summary.ytd_deprn%type;
6511:
6512: cursor asset_deprn is
6513: select deprn_reserve, ytd_deprn

Line 6510: l_ytd_deprn fa_deprn_summary.ytd_deprn%type;

6506: l_corp_method_code fa_methods.method_code%type;
6507:
6508: /* Added for ENH 12600386 Start */
6509: l_deprn_reserve fa_deprn_summary.deprn_reserve%type;
6510: l_ytd_deprn fa_deprn_summary.ytd_deprn%type;
6511:
6512: cursor asset_deprn is
6513: select deprn_reserve, ytd_deprn
6514: from fa_deprn_summary

Line 6514: from fa_deprn_summary

6510: l_ytd_deprn fa_deprn_summary.ytd_deprn%type;
6511:
6512: cursor asset_deprn is
6513: select deprn_reserve, ytd_deprn
6514: from fa_deprn_summary
6515: where asset_id = p_asset_hdr_rec.asset_id
6516: and book_type_code = p_asset_hdr_rec.book_type_code
6517: and deprn_source_code = 'BOOKS';
6518: /* Added for ENH 12600386 End */