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_DISTRIBUTION_HISTORY

Line 516: , fa_distribution_history fdh

512: 'ACTIVE' status,
513: (fdh.units_assigned/fadd.current_units) ytd_prorate_factor,
514: (fdh.units_assigned/fadd.current_units) normal_prorate_factor
515: from fa_deprn_periods fdp
516: , fa_distribution_history fdh
517: , fa_additions fadd
518: , fa_transaction_headers fth
519: where fth.book_type_code = cp_book_type_code
520: and fdp.book_type_code = fth.book_type_code

Line 553: , fa_distribution_history fdh

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
556: and fdp.period_counter = fdd.period_counter
557: and fdp.fiscal_year = cp_fiscal_year

Line 647: FROM fa_distribution_history fdh,

643: fdh.units_assigned units_assigned,
644: nvl(fdh.units_assigned,0) + nvl(fdh.transaction_units,0) units_active,
645: fdp.period_counter period_counter_created,
646: fdp.fiscal_year fiscal_year
647: FROM fa_distribution_history fdh,
648: fa_deprn_periods fdp
649: WHERE fdh.book_type_code = fp_book_type_code
650: AND fdh.asset_id = fp_asset_id
651: AND fdh.transaction_header_id_out IS NULL

Line 842: FROM fa_distribution_history fdh,

838: nvl(fdh.units_assigned,0) + nvl(fdh.transaction_units,0) units_active,
839: fdp.period_counter period_counter_created,
840: Null period_counter_closed ,
841: fdp.fiscal_year fiscal_year,'Y' Active_flag
842: FROM fa_distribution_history fdh,
843: fa_deprn_periods fdp
844: WHERE fdh.book_type_code = fp_book_type_code
845: AND fdh.asset_id = fp_asset_id
846: AND fdh.transaction_header_id_out IS NULL

Line 856: FROM fa_distribution_history fdh,

852: nvl(fdh.units_assigned,0) + nvl(fdh.transaction_units,0) units_active,
853: fdp2.period_counter period_counter_created,
854: fdp3.period_counter period_counter_closed,
855: fdp2.fiscal_year fiscal_year,'N' Active_flag
856: FROM fa_distribution_history fdh,
857: fa_deprn_periods fdp1,
858: fa_deprn_periods fdp2,
859: fa_deprn_periods fdp3
860: WHERE fdh.book_type_code = fp_book_type_code

Line 1315: --- get the account from the fa_adjustmemts and fa_distribution_history if not found im

1311: l_account_ccid := l_expense_ccid;
1312: END IF;
1313: END IF;
1314: CLOSE c_get_accounts;
1315: --- get the account from the fa_adjustmemts and fa_distribution_history if not found im
1316: -- fa_distribution_accounts.
1317:
1318: IF (l_account_ccid = -1) THEN
1319: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,' Failed to get account ccid from distribution accounts *****');

Line 1349: ,fa_distribution_history d

1345:
1346: SELECT a.category_id
1347: INTO l_category_id
1348: FROM fa_asset_history a
1349: ,fa_distribution_history d
1350: WHERE d.distribution_id = l_dist_id(l_loop_count)
1351: AND a.asset_id = d.asset_id
1352: AND d.date_effective >= a.date_effective
1353: AND d.date_effective < nvl(a.date_ineffective,sysdate);