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_CALC_DEPRN_BASIS2_PKG dependencies on FA_TRANSACTION_HEADERS

Line 382: from fa_transaction_headers h,

378: cursor C_MTC_BOOK
379: is
380: select nvl(h.amortization_start_date,h.transaction_date_entered),
381: nvl(bk.cost,0)
382: from fa_transaction_headers h,
383: fa_books bk
384: where h.transaction_header_id =
385: (select max(transaction_header_id_out)
386: from fa_books b,

Line 400: from fa_transaction_headers h,

396: cursor C_MTC_BOOK_M
397: is
398: select nvl(h.amortization_start_date,h.transaction_date_entered),
399: nvl(bk.cost,0)
400: from fa_transaction_headers h,
401: fa_mc_books bk
402: where h.transaction_header_id =
403: (select max(transaction_header_id_out)
404: from fa_mc_books b,

Line 1378: fa_transaction_headers th1,

1374: decode(adj.debit_credit_flag,
1375: 'DR',adj.adjustment_amount,
1376: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1377: from fa_adjustments adj,
1378: fa_transaction_headers th1,
1379: fa_transaction_headers th2
1380: where adj.asset_id = px_rule_in.asset_id
1381: and adj.book_type_code = px_rule_in.book_type_code
1382: and adj.period_counter_created = px_rule_in.period_counter

Line 1379: fa_transaction_headers th2

1375: 'DR',adj.adjustment_amount,
1376: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1377: from fa_adjustments adj,
1378: fa_transaction_headers th1,
1379: fa_transaction_headers th2
1380: where adj.asset_id = px_rule_in.asset_id
1381: and adj.book_type_code = px_rule_in.book_type_code
1382: and adj.period_counter_created = px_rule_in.period_counter
1383: and adj.transaction_header_id = th1.transaction_header_id

Line 1401: fa_transaction_headers th1,

1397: decode(adj.debit_credit_flag,
1398: 'DR',adj.adjustment_amount,
1399: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1400: from fa_mc_adjustments adj,
1401: fa_transaction_headers th1,
1402: fa_transaction_headers th2
1403: where adj.asset_id = px_rule_in.asset_id
1404: and adj.book_type_code = px_rule_in.book_type_code
1405: and adj.period_counter_created = px_rule_in.period_counter

Line 1402: fa_transaction_headers th2

1398: 'DR',adj.adjustment_amount,
1399: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1400: from fa_mc_adjustments adj,
1401: fa_transaction_headers th1,
1402: fa_transaction_headers th2
1403: where adj.asset_id = px_rule_in.asset_id
1404: and adj.book_type_code = px_rule_in.book_type_code
1405: and adj.period_counter_created = px_rule_in.period_counter
1406: and adj.transaction_header_id = th1.transaction_header_id

Line 1427: fa_transaction_headers th,

1423: decode(adj.debit_credit_flag,
1424: 'DR',adj.adjustment_amount,
1425: 'CR',-adj.adjustment_amount))),0) current_period_expense
1426: from fa_adjustments adj,
1427: fa_transaction_headers th,
1428: fa_deprn_periods dp
1429: where adj.asset_id = px_rule_in.asset_id
1430: and adj.book_type_code = px_rule_in.book_type_code
1431: and dp.book_type_code = px_rule_in.book_type_code

Line 1445: fa_transaction_headers th,

1441: decode(adj.debit_credit_flag,
1442: 'DR',adj.adjustment_amount,
1443: 'CR',-adj.adjustment_amount))),0) current_period_expense
1444: from fa_mc_adjustments adj,
1445: fa_transaction_headers th,
1446: fa_mc_deprn_periods dp
1447: where adj.asset_id = px_rule_in.asset_id
1448: and adj.book_type_code = px_rule_in.book_type_code
1449: and dp.book_type_code = px_rule_in.book_type_code

Line 1779: FA_TRANSACTION_HEADERS TH,

1775: -- Get Eofy reserve retired on current fiscal year
1776: Cursor C_EOFY_RESERVE_RETIRED is
1777: select nvl(sum(RET.EOFY_RESERVE),0)
1778: from FA_RETIREMENTS RET,
1779: FA_TRANSACTION_HEADERS TH,
1780: FA_DEPRN_PERIODS DP,
1781: FA_FISCAL_YEAR FY,
1782: FA_BOOK_CONTROLS BC
1783: where RET.ASSET_ID= px_rule_in.asset_id

Line 1799: FA_TRANSACTION_HEADERS TH,

1795:
1796: Cursor C_EOFY_RESERVE_RETIRED_M is
1797: select nvl(sum(RET.EOFY_RESERVE),0)
1798: from FA_MC_RETIREMENTS RET,
1799: FA_TRANSACTION_HEADERS TH,
1800: FA_MC_DEPRN_PERIODS DP,
1801: FA_FISCAL_YEAR FY,
1802: FA_MC_BOOK_CONTROLS MBC,
1803: FA_BOOK_CONTROLS BC

Line 1824: FA_TRANSACTION_HEADERS TH,

1820:
1821: Cursor GP_EOFY_RESERVE_RETIRED is
1822: select nvl(sum(RET.EOFY_RESERVE),0)
1823: from FA_RETIREMENTS RET,
1824: FA_TRANSACTION_HEADERS TH,
1825: FA_DEPRN_PERIODS DP,
1826: FA_FISCAL_YEAR FY,
1827: FA_BOOK_CONTROLS BC
1828: where TH.ASSET_ID= px_rule_in.asset_id

Line 1850: FA_TRANSACTION_HEADERS TH,

1846:
1847: Cursor GP_EOFY_RESERVE_RETIRED_M is
1848: select nvl(sum(RET.EOFY_RESERVE),0)
1849: from FA_MC_RETIREMENTS RET,
1850: FA_TRANSACTION_HEADERS TH,
1851: FA_MC_DEPRN_PERIODS DP,
1852: FA_FISCAL_YEAR FY,
1853: FA_MC_BOOK_CONTROLS MBC,
1854: FA_BOOK_CONTROLS BC

Line 2252: from fa_books bk, fa_transaction_headers th

2248:
2249: /*bug#16426081 starts*/
2250: cursor c_adj_cost_diff is
2251: select (bk.adjusted_cost-bk.recoverable_cost) adj_cost_diff, th.amortization_start_date,th.transaction_header_id
2252: from fa_books bk, fa_transaction_headers th
2253: where bk.asset_id = th.asset_id
2254: and bk.book_type_code = px_rule_in.book_type_code
2255: and bk.asset_id = px_rule_in.asset_id
2256: and th.transaction_header_id = bk.transaction_header_id_in

Line 2262: from fa_mc_books bk, fa_transaction_headers th

2258: order by th.transaction_header_id desc;
2259:
2260: cursor c_adj_cost_diff_m is
2261: select (bk.adjusted_cost-bk.recoverable_cost) adj_cost_diff, th.amortization_start_date,th.transaction_header_id
2262: from fa_mc_books bk, fa_transaction_headers th
2263: where bk.asset_id = th.asset_id
2264: and bk.book_type_code = px_rule_in.book_type_code
2265: and bk.asset_id = px_rule_in.asset_id
2266: and th.transaction_header_id = bk.transaction_header_id_in

Line 2274: from fa_transaction_headers th

2270:
2271:
2272: cursor c_min_amrt_date(p_adjcost_thid in number) is
2273: select min(amortization_start_date)
2274: from fa_transaction_headers th
2275: where th.book_type_code = px_rule_in.book_type_code
2276: and th.asset_id = px_rule_in.asset_id
2277: and th.transaction_header_id > p_adjcost_thid
2278: and nvl(th.transaction_key,'zz') <> 'BA';