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_IMP_IAC_TRANSFER_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 786: fa_distribution_history dh,

782: dh.distribution_id,
783: dh.code_combination_id,
784: dh.date_ineffective
785: FROM
786: fa_distribution_history dh,
787: fa_deprn_periods dp
788: WHERE
789: dh.asset_id= p_asset_id AND
790: dh.book_type_code=p_book_type_code AND

Line 810: fa_distribution_history dh

806: ,p_fiscal_year in NUMBER)
807: IS
808: SELECT dp.period_counter
809: FROM fa_deprn_periods dp,
810: fa_distribution_history dh
811: WHERE (dh.date_ineffective between dp.period_open_date and dp.period_close_date) AND
812: dp.book_type_code=p_book_type_code AND
813: dp.fiscal_year=p_fiscal_year AND
814: dh.book_type_code=p_book_type_code AND

Line 851: FROM fa_distribution_history

847:
848: CURSOR C_active_dists
849: IS
850: SELECT count(*)
851: FROM fa_distribution_history
852: WHERE book_type_code=p_book_type_code AND
853: asset_id=p_asset_id AND
854: date_ineffective IS NULL;
855:

Line 1649: FROM fa_distribution_history

1645: ||drec.distribution_id );
1646:
1647: SELECT units_assigned
1648: INTO l_units
1649: FROM fa_distribution_history
1650: WHERE distribution_id = drec.distribution_id ;
1651:
1652: IF l_units =0
1653: THEN