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.IGI_IAC_REVAL_UTILITIES dependencies on FA_DEPRN_DETAIL

Line 534: from fa_deprn_detail

530: and distribution_id = fdh.distribution_id
531: and transaction_header_id = fth.transaction_header_id
532: )
533: and not exists ( select distribution_id
534: from fa_deprn_detail
535: where asset_id = fth.asset_id
536: and book_type_code = fth.book_type_code
537: and distribution_id = fdh.distribution_id
538: )

Line 551: from fa_deprn_detail fdd

547: nvl(fdh.units_assigned,0) + nvl(fdh.transaction_units,0) units_active,
548: 'ACTIVE' status,
549: (fdh.units_assigned/cp_total_units) ytd_prorate_factor,
550: (fdh.units_assigned/cp_total_units) normal_prorate_factor
551: from fa_deprn_detail fdd
552: , fa_deprn_periods fdp
553: , fa_distribution_history fdh
554: where fdd.book_type_code = cp_book_type_code
555: and fdp.book_type_code = fdd.book_type_code

Line 566: from fa_deprn_detail

562: and fdh.transaction_header_id_out is null
563: and cp_total_units <> 0 -- avoid divide by zero issues
564: and ( fdd.asset_id, fdd.distribution_id, fdd.period_counter )
565: in ( select asset_id, distribution_id, max(period_counter)
566: from fa_deprn_detail
567: where book_type_code = fdd.book_type_code
568: and asset_id = fdd.asset_id
569: group by asset_id, distribution_id
570: );