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_RX_GROUP dependencies on FA_FISCAL_YEAR

Line 297: fa_fiscal_year fy,

293: l_group_rec.reserve_retired,
294: l_group_rec.recapture_amount
295: FROM fa_retirements ret,
296: fa_book_controls bc,
297: fa_fiscal_year fy,
298: fa_transaction_headers thg,
299: fa_transaction_headers thm
300: WHERE bc.book_type_code = p_book_type_code
301: AND fy.fiscal_year = l_info_rec.fiscal_year

Line 335: fa_fiscal_year fy,

331: INTO l_group_adjustment_amount,
332: l_second_half_grp_adjustment
333: FROM fa_adjustments adj,
334: fa_book_controls bc,
335: fa_fiscal_year fy,
336: fa_transaction_headers thg
337: WHERE thg.asset_id = l_group_rec.asset_id
338: AND thg.book_type_code = p_book_type_code
339: AND thg.member_transaction_header_id IS NULL

Line 992: fa_fiscal_year fy,

988: ''CIP COST-CR'', -adj.adjustment_amount, 0)), 0)
989: adjustment_amount
990: FROM fa_adjustments adj,
991: fa_book_controls bc,
992: fa_fiscal_year fy,
993: fa_transaction_headers thm,
994: fa_books bkm
995: WHERE bkm.group_asset_id = ' || p_group_rec.asset_id || '
996: AND adj.asset_id = bkm.asset_id

Line 1042: fa_fiscal_year fy,

1038: NVL(SUM(ret.cost_retired), 0) cost_retired,
1039: NVL(SUM(ret.reserve_retired), 0) reserve_retired
1040: FROM fa_retirements ret,
1041: fa_book_controls bc,
1042: fa_fiscal_year fy,
1043: fa_transaction_headers thm,
1044: fa_books bkm
1045: WHERE bkm.group_asset_id = ' || p_group_asset_id || '
1046: AND bc.book_type_code = ''' || p_info_rec.book_type_code || '''