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_TRANSACTION_HEADERS

Line 71: fa_transaction_headers thg

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'
75: AND fad.adjustment_type IN ('PROCEEDS CLR','REMOVALCOST CLR')

Line 91: fa_transaction_headers thg

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'
95: AND fad.adjustment_type IN ('PROCEEDS CLR','REMOVALCOST CLR')

Line 369: fa_transaction_headers thg,

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
373: AND fy.fiscal_year_name = bc.fiscal_year_name

Line 370: fa_transaction_headers thm

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
373: AND fy.fiscal_year_name = bc.fiscal_year_name
374: AND thm.book_type_code = bc.book_type_code

Line 399: fa_transaction_headers thg,

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
403: AND fy.fiscal_year_name = bc.fiscal_year_name

Line 400: fa_transaction_headers thm

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
403: AND fy.fiscal_year_name = bc.fiscal_year_name
404: AND thm.book_type_code = bc.book_type_code

Line 466: fa_transaction_headers thg

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
470: AND thg.transaction_header_id = adj.transaction_header_id

Line 495: fa_transaction_headers thg

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
499: AND thg.transaction_header_id = adj.transaction_header_id

Line 536: fa_transaction_headers fth,

532: SELECT NVL(SUM(bk.cost - bk_old.cost),0)
533: INTO l_group_reclass_cost_in_out
534: FROM fa_books bk,
535: fa_books bk_old,
536: fa_transaction_headers fth,
537: fa_book_controls bc,
538: fa_deprn_periods dp
539: WHERE bk.transaction_header_id_in = fth.transaction_header_id
540: AND bk_old.transaction_header_id_out = fth.transaction_header_id

Line 559: fa_transaction_headers thg

555: 'RESERVE-CR', adj.adjustment_amount,
556: 'RESERVE-DR', -adj.adjustment_amount,0)), 0) reserve
557: INTO l_group_reclass_rsv_in_out
558: FROM fa_adjustments adj,
559: fa_transaction_headers thg
560: WHERE adj.asset_id = l_group_rec.asset_id
561: AND adj.book_type_code = p_book_type_code
562: AND thg.transaction_header_id = adj.transaction_header_id
563: AND thg.asset_id = l_group_rec.asset_id

Line 575: fa_transaction_headers fth,

571: SELECT SUM(bk.cost - bk_old.cost)
572: INTO l_group_reclass_cost_in_out
573: FROM fa_mc_books bk,
574: fa_mc_books bk_old,
575: fa_transaction_headers fth,
576: fa_mc_book_controls bc,
577: fa_book_controls bc1,
578: fa_mc_deprn_periods dp
579: WHERE bk.transaction_header_id_in = fth.transaction_header_id

Line 604: fa_transaction_headers thg

600: 'RESERVE-CR', adj.adjustment_amount,
601: 'RESERVE-DR', -adj.adjustment_amount,0)), 0) reserve
602: INTO l_group_reclass_rsv_in_out
603: FROM fa_mc_adjustments adj,
604: fa_transaction_headers thg
605: WHERE adj.asset_id = l_group_rec.asset_id
606: AND adj.book_type_code = p_book_type_code
607: AND thg.transaction_header_id = adj.transaction_header_id
608: AND thg.asset_id = l_group_rec.asset_id

Line 1274: fa_transaction_headers thm,

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
1278: AND bkm.transaction_header_id_in = thm.transaction_header_id

Line 1320: fa_transaction_headers thm,

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
1324: AND bkm.transaction_header_id_in = thm.transaction_header_id

Line 1378: fa_transaction_headers thm,

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 || '''
1382: AND fy.fiscal_year = ' || p_info_rec.fiscal_year || '

Line 1405: fa_transaction_headers thm,

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 || '''
1409: AND fy.fiscal_year = ' || p_info_rec.fiscal_year || '

Line 1699: fa_transaction_headers thg,

1695: if(P_MRCSOBTYPE <> 'R') then -- MRC
1696: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1697: INTO l_group_reclass_out
1698: FROM fa_adjustments adj,
1699: fa_transaction_headers thg,
1700: fa_books bkm
1701: WHERE adj.asset_id = p_group_rec.asset_id
1702: AND adj.book_type_code = p_info_rec.book_type_code
1703: AND thg.transaction_header_id = adj.transaction_header_id

Line 1717: fa_transaction_headers thg,

1713: else
1714: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1715: INTO l_group_reclass_out
1716: FROM fa_mc_adjustments adj,
1717: fa_transaction_headers thg,
1718: fa_mc_books bkm
1719: WHERE adj.asset_id = p_group_rec.asset_id
1720: AND adj.book_type_code = p_info_rec.book_type_code
1721: AND thg.transaction_header_id = adj.transaction_header_id

Line 1758: fa_transaction_headers thg,

1754: if(P_MRCSOBTYPE <> 'R') then -- MRC
1755: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1756: INTO l_group_reclass_in
1757: FROM fa_adjustments adj,
1758: fa_transaction_headers thg,
1759: fa_books bkm
1760: WHERE adj.asset_id = p_group_rec.asset_id
1761: AND adj.book_type_code = p_info_rec.book_type_code
1762: AND thg.transaction_header_id = adj.transaction_header_id

Line 1775: fa_transaction_headers thg,

1771: else
1772: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1773: INTO l_group_reclass_in
1774: FROM fa_mc_adjustments adj,
1775: fa_transaction_headers thg,
1776: fa_mc_books bkm
1777: WHERE adj.asset_id = p_group_rec.asset_id
1778: AND adj.book_type_code = p_info_rec.book_type_code
1779: AND thg.transaction_header_id = adj.transaction_header_id