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

Line 79: FROM fa_distribution_history fdh

75: AND fav.asset_category_id = fcb.category_id
76: AND fav.asset_type = 'CAPITALIZED'
77: AND fav.asset_id IN
78: (SELECT DISTINCT fdh.asset_id
79: FROM fa_distribution_history fdh
80: ,fa_transaction_headers fth
81: WHERE fdh.asset_id = fth.asset_id
82: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
83: AND EXISTS

Line 127: FROM fa_distribution_history fdh

123: AND fav.asset_category_id = fcb.category_id
124: AND fav.asset_type = 'CAPITALIZED'
125: AND fav.asset_id IN
126: (SELECT DISTINCT fdh.asset_id
127: FROM fa_distribution_history fdh
128: ,fa_transaction_headers fth
129: WHERE fdh.asset_id = fth.asset_id
130: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
131: AND EXISTS

Line 175: FROM fa_distribution_history fdh

171: AND fav.asset_category_id = fcb.category_id
172: AND fav.asset_type = 'CAPITALIZED'
173: AND fav.asset_id IN
174: (SELECT DISTINCT fdh.asset_id
175: FROM fa_distribution_history fdh
176: ,fa_transaction_headers fth
177: WHERE fdh.asset_id = fth.asset_id
178: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
179: AND EXISTS