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.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_DEPRN_PERIODS_MRC_V

Line 303: fa_deprn_periods_mrc_v dp ,

299: SELECT fb.cost
300: INTO p_asset_cost
301: FROM fa_books_mrc_v fb ,
302: fa_calendar_periods cp ,
303: fa_deprn_periods_mrc_v dp ,
304: fa_transaction_headers th ,
305: fa_asset_history ah ,
306: fa_additions ad ,
307: fa_book_controls_mrc_v bc

Line 523: fa_deprn_periods_mrc_v dp

519: BEGIN
520: SELECT nvl(bk.cost,0)
521: INTO p_historical_cost_begin_period
522: FROM fa_books_mrc_v bk,
523: fa_deprn_periods_mrc_v dp
524: WHERE bk.book_type_code = p_hist_book_type_code
525: AND bk.asset_id = p_asset_id
526: AND bk.book_type_code = dp.book_type_code
527: AND dp.period_open_date between bk.date_effective and nvl(bk.date_ineffective,dp.period_open_date)

Line 597: fa_deprn_periods_mrc_v dp

593: BEGIN
594: SELECT nvl(bk.cost,0)
595: INTO p_historical_cost_end_period
596: FROM fa_books_mrc_v bk,
597: fa_deprn_periods_mrc_v dp
598: WHERE bk.book_type_code = p_hist_book_type_code
599: AND bk.asset_id = p_asset_id
600: AND bk.book_type_code = dp.book_type_code
601: AND dp.period_close_date between bk.date_effective and nvl(bk.date_ineffective,dp.period_close_date)

Line 612: fa_deprn_periods_mrc_v dp

608: BEGIN
609: SELECT nvl(bk.cost,0)
610: INTO p_adjusted_cost_end_period
611: FROM fa_books_mrc_v bk,
612: fa_deprn_periods_mrc_v dp
613: WHERE bk.book_type_code = p_adj_book_type_code
614: AND bk.asset_id = p_asset_id
615: AND bk.book_type_code = dp.book_type_code
616: AND dp.period_close_date between bk.date_effective and nvl(bk.date_ineffective,dp.period_close_date)

Line 1657: fa_deprn_periods_mrc_v dp,

1653: th.transaction_header_id,
1654: ah.asset_type,
1655: nvl (ah.units,0)
1656: FROM fa_transaction_headers th,
1657: fa_deprn_periods_mrc_v dp,
1658: fa_asset_history ah
1659: WHERE dp.book_type_code = p_corp_book
1660: AND dp.period_counter between p_period_counter_from and p_period_counter_to
1661: AND th.book_type_code = dp.book_type_code

Line 1693: fa_deprn_periods_mrc_v dp,

1689: -1,
1690: ah.asset_type,
1691: nvl (ah.units,0)
1692: FROM fa_books bk,
1693: fa_deprn_periods_mrc_v dp,
1694: fa_asset_history ah
1695: WHERE dp.book_type_code = p_corp_book
1696: AND bk.book_type_code = dp.book_type_code
1697: AND bk.asset_id = ah.asset_id