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_BOOKS_MRC_V

Line 301: FROM fa_books_mrc_v fb ,

297: IF p_mrcsobtype = 'R' THEN
298: BEGIN
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 ,

Line 522: FROM fa_books_mrc_v bk,

518: BEGIN
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

Line 596: FROM fa_books_mrc_v bk,

592: BEGIN
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

Line 611: FROM fa_books_mrc_v bk,

607:
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

Line 1155: FROM fa_books_mrc_v bk, fa_transaction_headers th

1151: SELECT bk.cost,
1152: bk.period_counter_fully_retired
1153: INTO l_hist_cost_retirement,
1154: l_period_counter_fully_retired
1155: FROM fa_books_mrc_v bk, fa_transaction_headers th
1156: WHERE bk.book_type_code = p_hist_book_type_code
1157: AND bk.asset_id = p_asset_id
1158: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1159: FROM fa_books bk1

Line 1178: FROM fa_books_mrc_v bk, fa_transaction_headers th

1174: SELECT bk.cost,
1175: bk.date_placed_in_service
1176: INTO l_adj_cost_retirement,
1177: l_date_placed_in_service
1178: FROM fa_books_mrc_v bk, fa_transaction_headers th
1179: WHERE bk.book_type_code = p_adj_book_type_code
1180: AND bk.asset_id = p_asset_id
1181: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1182: FROM fa_books bk1