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 291: from fa_transaction_headers h,

287: cursor C_MTC_BOOK
288: is
289: select nvl(h.amortization_start_date,h.transaction_date_entered),
290: nvl(bk.cost,0)
291: from fa_transaction_headers h,
292: fa_books bk
293: where h.transaction_header_id =
294: (select max(transaction_header_id_out)
295: from fa_books b,

Line 309: from fa_transaction_headers h,

305: cursor C_MTC_BOOK_M
306: is
307: select nvl(h.amortization_start_date,h.transaction_date_entered),
308: nvl(bk.cost,0)
309: from fa_transaction_headers h,
310: fa_books bk
311: where h.transaction_header_id =
312: (select max(transaction_header_id_out)
313: from fa_books_mrc_v b,

Line 1200: fa_transaction_headers th1,

1196: decode(adj.debit_credit_flag,
1197: 'DR',adj.adjustment_amount,
1198: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1199: from fa_adjustments adj,
1200: fa_transaction_headers th1,
1201: fa_transaction_headers th2
1202: where adj.asset_id = px_rule_in.asset_id
1203: and adj.book_type_code = px_rule_in.book_type_code
1204: and adj.period_counter_created = px_rule_in.period_counter

Line 1201: fa_transaction_headers th2

1197: 'DR',adj.adjustment_amount,
1198: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1199: from fa_adjustments adj,
1200: fa_transaction_headers th1,
1201: fa_transaction_headers th2
1202: where adj.asset_id = px_rule_in.asset_id
1203: and adj.book_type_code = px_rule_in.book_type_code
1204: and adj.period_counter_created = px_rule_in.period_counter
1205: and adj.transaction_header_id = th1.transaction_header_id

Line 1223: fa_transaction_headers th1,

1219: decode(adj.debit_credit_flag,
1220: 'DR',adj.adjustment_amount,
1221: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1222: from fa_adjustments_mrc_v adj,
1223: fa_transaction_headers th1,
1224: fa_transaction_headers th2
1225: where adj.asset_id = px_rule_in.asset_id
1226: and adj.book_type_code = px_rule_in.book_type_code
1227: and adj.period_counter_created = px_rule_in.period_counter

Line 1224: fa_transaction_headers th2

1220: 'DR',adj.adjustment_amount,
1221: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1222: from fa_adjustments_mrc_v adj,
1223: fa_transaction_headers th1,
1224: fa_transaction_headers th2
1225: where adj.asset_id = px_rule_in.asset_id
1226: and adj.book_type_code = px_rule_in.book_type_code
1227: and adj.period_counter_created = px_rule_in.period_counter
1228: and adj.transaction_header_id = th1.transaction_header_id

Line 1247: fa_transaction_headers th,

1243: decode(adj.debit_credit_flag,
1244: 'DR',adj.adjustment_amount,
1245: 'CR',-adj.adjustment_amount))),0) current_period_expense
1246: from fa_adjustments adj,
1247: fa_transaction_headers th,
1248: fa_deprn_periods dp
1249: where adj.asset_id = px_rule_in.asset_id
1250: and adj.book_type_code = px_rule_in.book_type_code
1251: and dp.book_type_code = px_rule_in.book_type_code

Line 1265: fa_transaction_headers th,

1261: decode(adj.debit_credit_flag,
1262: 'DR',adj.adjustment_amount,
1263: 'CR',-adj.adjustment_amount))),0) current_period_expense
1264: from fa_adjustments_mrc_v adj,
1265: fa_transaction_headers th,
1266: fa_deprn_periods_mrc_v dp
1267: where adj.asset_id = px_rule_in.asset_id
1268: and adj.book_type_code = px_rule_in.book_type_code
1269: and dp.book_type_code = px_rule_in.book_type_code

Line 1607: FA_TRANSACTION_HEADERS TH,

1603: -- Get Eofy reserve retired on current fiscal year
1604: Cursor C_EOFY_RESERVE_RETIRED is
1605: select nvl(sum(RET.EOFY_RESERVE),0)
1606: from FA_RETIREMENTS RET,
1607: FA_TRANSACTION_HEADERS TH,
1608: FA_DEPRN_PERIODS DP,
1609: FA_FISCAL_YEAR FY,
1610: FA_BOOK_CONTROLS BC
1611: where RET.ASSET_ID= px_rule_in.asset_id

Line 1627: FA_TRANSACTION_HEADERS TH,

1623:
1624: Cursor C_EOFY_RESERVE_RETIRED_M is
1625: select nvl(sum(RET.EOFY_RESERVE),0)
1626: from FA_RETIREMENTS_MRC_V RET,
1627: FA_TRANSACTION_HEADERS TH,
1628: FA_DEPRN_PERIODS_MRC_V DP,
1629: FA_FISCAL_YEAR FY,
1630: FA_BOOK_CONTROLS_MRC_V BC
1631: where RET.ASSET_ID= px_rule_in.asset_id

Line 1647: FA_TRANSACTION_HEADERS TH,

1643:
1644: Cursor GP_EOFY_RESERVE_RETIRED is
1645: select nvl(sum(RET.EOFY_RESERVE),0)
1646: from FA_RETIREMENTS RET,
1647: FA_TRANSACTION_HEADERS TH,
1648: FA_DEPRN_PERIODS DP,
1649: FA_FISCAL_YEAR FY,
1650: FA_BOOK_CONTROLS BC
1651: where TH.ASSET_ID= px_rule_in.asset_id

Line 1673: FA_TRANSACTION_HEADERS TH,

1669:
1670: Cursor GP_EOFY_RESERVE_RETIRED_M is
1671: select nvl(sum(RET.EOFY_RESERVE),0)
1672: from FA_RETIREMENTS_MRC_V RET,
1673: FA_TRANSACTION_HEADERS TH,
1674: FA_DEPRN_PERIODS_MRC_V DP,
1675: FA_FISCAL_YEAR FY,
1676: FA_BOOK_CONTROLS_MRC_V BC
1677: where TH.ASSET_ID= px_rule_in.asset_id