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

Line 218: SELECT sum(units_assigned) FROM FA_DISTRIBUTION_HISTORY

214: WHERE asset_id = p_asset_id
215: AND date_ineffective IS NULL;
216:
217: CURSOR get_dh_units IS
218: SELECT sum(units_assigned) FROM FA_DISTRIBUTION_HISTORY
219: WHERE asset_id = p_asset_id
220: AND date_ineffective is NULL;
221: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_units';
222: BEGIN

Line 805: fa_distribution_history dh,

801: dh.location_id,
802: dh.assigned_to,
803: ad.asset_number
804: from fa_book_controls bc,
805: fa_distribution_history dh,
806: fa_additions ad
807: where dh.asset_id = p_asset_hdr_rec.asset_id
808: and dh.book_type_code = bc.distribution_source_book
809: and bc.book_type_code = p_asset_hdr_rec.book_type_code