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 70: fa_fiscal_year fy,

66: SELECT NVL(SUM(NVL(fad.adjustment_amount,0)),0) adj_amt,
67: fad.adjustment_type adj_type
68: FROM fa_adjustments fad,
69: fa_book_controls bc,
70: fa_fiscal_year fy,
71: fa_transaction_headers thg
72: WHERE fad.asset_id = l_group_rec.asset_id
73: AND fad.book_type_code = p_book_type_code
74: AND fad.source_type_code = 'RETIREMENT'

Line 90: fa_fiscal_year fy,

86: SELECT NVL(SUM(NVL(fad.adjustment_amount,0)),0) adj_amt,
87: fad.adjustment_type adj_type
88: FROM fa_mc_adjustments fad,
89: fa_book_controls bc,
90: fa_fiscal_year fy,
91: fa_transaction_headers thg
92: WHERE fad.asset_id = l_group_rec.asset_id
93: AND fad.book_type_code = p_book_type_code
94: AND fad.source_type_code = 'RETIREMENT'

Line 368: fa_fiscal_year fy,

364: l_group_rec.reserve_retired,
365: l_group_rec.recapture_amount
366: FROM fa_retirements ret,
367: fa_book_controls bc,
368: fa_fiscal_year fy,
369: fa_transaction_headers thg,
370: fa_transaction_headers thm
371: WHERE bc.book_type_code = p_book_type_code
372: AND fy.fiscal_year = l_info_rec.fiscal_year

Line 398: fa_fiscal_year fy,

394: l_group_rec.reserve_retired,
395: l_group_rec.recapture_amount
396: FROM fa_mc_retirements ret,
397: fa_book_controls bc,
398: fa_fiscal_year fy,
399: fa_transaction_headers thg,
400: fa_transaction_headers thm
401: WHERE bc.book_type_code = p_book_type_code
402: AND fy.fiscal_year = l_info_rec.fiscal_year

Line 465: fa_fiscal_year fy,

461: INTO l_group_adjustment_amount,
462: l_second_half_grp_adjustment
463: FROM fa_adjustments adj,
464: fa_book_controls bc,
465: fa_fiscal_year fy,
466: fa_transaction_headers thg
467: WHERE thg.asset_id = l_group_rec.asset_id
468: AND thg.book_type_code = p_book_type_code
469: AND thg.member_transaction_header_id IS NULL

Line 494: fa_fiscal_year fy,

490: INTO l_group_adjustment_amount,
491: l_second_half_grp_adjustment
492: FROM fa_mc_adjustments adj,
493: fa_book_controls bc,
494: fa_fiscal_year fy,
495: fa_transaction_headers thg
496: WHERE thg.asset_id = l_group_rec.asset_id
497: AND thg.book_type_code = p_book_type_code
498: AND thg.member_transaction_header_id IS NULL

Line 1273: fa_fiscal_year fy,

1269: ''CIP COST-CR'', -adj.adjustment_amount, 0)), 0)
1270: adjustment_amount
1271: FROM fa_adjustments adj,
1272: fa_book_controls bc,
1273: fa_fiscal_year fy,
1274: fa_transaction_headers thm,
1275: fa_books bkm
1276: WHERE bkm.group_asset_id = ' || p_group_rec.asset_id || '
1277: AND adj.asset_id = bkm.asset_id

Line 1319: fa_fiscal_year fy,

1315: adjustment_amount
1316: FROM fa_mc_adjustments adj,
1317: fa_mc_book_controls bc,
1318: fa_book_controls bc1,
1319: fa_fiscal_year fy,
1320: fa_transaction_headers thm,
1321: fa_mc_books bkm
1322: WHERE bkm.group_asset_id = ' || p_group_rec.asset_id || '
1323: AND adj.asset_id = bkm.asset_id

Line 1377: fa_fiscal_year fy,

1373: NVL(SUM(ret.cost_retired), 0) cost_retired,
1374: NVL(SUM(ret.reserve_retired), 0) reserve_retired
1375: FROM fa_retirements ret,
1376: fa_book_controls bc,
1377: fa_fiscal_year fy,
1378: fa_transaction_headers thm,
1379: fa_books bkm
1380: WHERE bkm.group_asset_id = ' || p_group_asset_id || '
1381: AND bc.book_type_code = ''' || p_info_rec.book_type_code || '''

Line 1404: fa_fiscal_year fy,

1400: NVL(SUM(ret.cost_retired), 0) cost_retired,
1401: NVL(SUM(ret.reserve_retired), 0) reserve_retired
1402: FROM fa_mc_retirements ret,
1403: fa_mc_book_controls bc,
1404: fa_fiscal_year fy,
1405: fa_transaction_headers thm,
1406: fa_mc_books bkm
1407: WHERE bkm.group_asset_id = ' || p_group_asset_id || '
1408: AND bc.book_type_code = ''' || p_info_rec.book_type_code || '''