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.IGIRX_IMP_IAC_REP dependencies on FA_DISTRIBUTION_HISTORY

Line 420: Fa_Distribution_History dh,

416: nvl(ii.Operating_Account_Backlog * (dh.units_Assigned/ad.current_units) ,0) Operating_Account_Backlog,
417: nvl(ii.NBV_Hist * (dh.units_Assigned/ad.current_units) ,0) NBV_Hist,
418: nvl(ii.NBV_MHCA * (dh.units_Assigned/ad.current_units) ,0) NBV_MHCA
419: FROM Igi_Imp_Iac_Interface ii,
420: Fa_Distribution_History dh,
421: Fa_Additions ad,
422: igi_imp_iac_controls ct
423: WHERE
424: ii.book_type_code=p_book_type_code AND

Line 471: fa_distribution_history dh

467: ,p_dist_source_book in VARCHAR2)
468: IS
469: SELECT dp.period_counter
470: FROM fa_deprn_periods dp,
471: fa_distribution_history dh
472: WHERE dh.date_ineffective between dp.period_open_date and dp.period_close_date AND
473: dp.book_type_code=p_book_type_code AND
474: dp.fiscal_year=p_fiscal_year AND
475: dh.book_type_code=p_dist_source_book AND

Line 524: FROM fa_distribution_history dh,

520: dh.distribution_id,
521: dh.code_combination_id,
522: dh.date_ineffective,
523: dh.location_id
524: FROM fa_distribution_history dh,
525: fa_deprn_periods dp
526: WHERE dh.asset_id= p_asset_id AND
527: dh.book_type_code=p_dist_source_book AND
528: (nvl(dh.date_ineffective,dp.period_open_date)>=dp.period_open_date) AND

Line 608: fa_distribution_history dh

604: cp_asset_id number,
605: cp_distribution_id number) IS
606: SELECT ah.category_id
607: FROM fa_asset_history ah,
608: fa_distribution_history dh
609: WHERE dh.book_type_code = cp_book_type_code AND
610: dh.asset_id = cp_asset_id AND
611: dh.distribution_id = cp_distribution_id AND
612: dh.asset_id = ah.asset_id AND