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

Line 891: FROM fa_distribution_history fad

887: AND (fth.transaction_date_entered <= x_Retire_Date
888: AND fth.transaction_type_code not in ('FULL RETIREMENT',
889: 'REINSTATEMENT')))
890: AND EXISTS ( SELECT 'X'
891: FROM fa_distribution_history fad
892: , gl_code_combinations gcc
893: WHERE fad.asset_id = faa.asset_id
894: AND fad.code_combination_id = gcc.code_combination_id
895: AND fad.date_ineffective IS NULL )

Line 956: FROM fa_distribution_history fad

952: AND (fth.transaction_date_entered <= x_Retire_Date
953: AND fth.transaction_type_code not in ('FULL RETIREMENT',
954: 'REINSTATEMENT')))
955: AND EXISTS ( SELECT 'X'
956: FROM fa_distribution_history fad
957: , gl_code_combinations gcc
958: WHERE fad.asset_id = faa.asset_id
959: AND fad.code_combination_id = gcc.code_combination_id
960: AND fad.date_ineffective IS NULL )

Line 1552: from fa_distribution_history

1548: , location_id
1549: , assigned_to
1550: , date_effective
1551: , transaction_header_id_in
1552: from fa_distribution_history
1553: where book_type_code = x_book_type_code
1554: and asset_id = x_asset_id
1555: and date_ineffective IS NULL;
1556: --order by date_effective asc;