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

Line 266: -- completely re-written. View jl_zz_fa_books_periods_v --

262: -- The latest transaction performed on an asset in a --
263: -- particular period is the one that defines the cost at --
264: -- the end of that period. --
265: -- Bug 3101070: Due to mrc changes, this function is --
266: -- completely re-written. View jl_zz_fa_books_periods_v --
267: -- has been replaced with the source code of the view. --
268: ------------------------------------------------------------
269: SELECT max(th.transaction_header_id) ,
270: max(dp.period_counter)

Line 273: FROM fa_books fb ,

269: SELECT max(th.transaction_header_id) ,
270: max(dp.period_counter)
271: INTO l_transaction_header_id,
272: l_period_counter
273: FROM fa_books fb ,
274: fa_calendar_periods cp ,
275: fa_deprn_periods dp ,
276: fa_transaction_headers th ,
277: fa_asset_history ah ,

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 329: FROM fa_books fb ,

325: ELSE
326: BEGIN
327: SELECT fb.cost
328: INTO p_asset_cost
329: FROM fa_books fb ,
330: fa_calendar_periods cp ,
331: fa_deprn_periods dp ,
332: fa_transaction_headers th ,
333: 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 737: FROM fa_books bk,

733:
734: BEGIN
735: SELECT nvl(bk.cost,0)
736: INTO p_historical_cost_begin_period
737: FROM fa_books bk,
738: fa_deprn_periods dp
739: WHERE bk.book_type_code = p_hist_book_type_code
740: AND bk.asset_id = p_asset_id
741: AND bk.book_type_code = dp.book_type_code

Line 829: FROM fa_books bk,

825:
826: BEGIN
827: SELECT nvl(bk.cost,0)
828: INTO p_historical_cost_end_period
829: FROM fa_books bk,
830: fa_deprn_periods dp
831: WHERE bk.book_type_code = p_hist_book_type_code
832: AND bk.asset_id = p_asset_id
833: AND bk.book_type_code = dp.book_type_code

Line 844: FROM fa_books bk,

840:
841: BEGIN
842: SELECT nvl(bk.cost,0)
843: INTO p_adjusted_cost_end_period
844: FROM fa_books bk,
845: fa_deprn_periods dp
846: WHERE bk.book_type_code = p_adj_book_type_code
847: AND bk.asset_id = p_asset_id
848: 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 1159: FROM fa_books bk1

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
1160: WHERE bk1.book_type_code = bk.book_type_code
1161: AND bk1.asset_id = bk.asset_id
1162: AND bk1.period_counter_fully_retired
1163: between p_period_counter_from and p_period_counter_to)

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

Line 1182: FROM fa_books bk1

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
1183: WHERE bk1.book_type_code = bk.book_type_code
1184: AND bk1.asset_id = bk.asset_id
1185: AND bk1.period_counter_fully_retired
1186: between p_period_counter_from and p_period_counter_to)

Line 1200: FROM fa_books bk, fa_transaction_headers th

1196: SELECT bk.cost,
1197: bk.period_counter_fully_retired
1198: INTO l_hist_cost_retirement,
1199: l_period_counter_fully_retired
1200: FROM fa_books bk, fa_transaction_headers th
1201: WHERE bk.book_type_code = p_hist_book_type_code
1202: AND bk.asset_id = p_asset_id
1203: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1204: FROM fa_books bk1

Line 1204: FROM fa_books bk1

1200: FROM fa_books bk, fa_transaction_headers th
1201: WHERE bk.book_type_code = p_hist_book_type_code
1202: AND bk.asset_id = p_asset_id
1203: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1204: FROM fa_books bk1
1205: WHERE bk1.book_type_code = bk.book_type_code
1206: AND bk1.asset_id = bk.asset_id
1207: AND bk1.period_counter_fully_retired
1208: between p_period_counter_from and p_period_counter_to)

Line 1223: FROM fa_books bk, fa_transaction_headers th

1219: SELECT bk.cost,
1220: bk.date_placed_in_service
1221: INTO l_adj_cost_retirement,
1222: l_date_placed_in_service
1223: FROM fa_books bk, fa_transaction_headers th
1224: WHERE bk.book_type_code = p_adj_book_type_code
1225: AND bk.asset_id = p_asset_id
1226: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1227: FROM fa_books bk1

Line 1227: FROM fa_books bk1

1223: FROM fa_books bk, fa_transaction_headers th
1224: WHERE bk.book_type_code = p_adj_book_type_code
1225: AND bk.asset_id = p_asset_id
1226: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1227: FROM fa_books bk1
1228: WHERE bk1.book_type_code = bk.book_type_code
1229: AND bk1.asset_id = bk.asset_id
1230: AND bk1.period_counter_fully_retired
1231: between p_period_counter_from and p_period_counter_to)

Line 1692: FROM fa_books bk,

1688: null,
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

Line 1748: FROM fa_books bk,

1744: null,
1745: -1,
1746: ah.asset_type,
1747: nvl (ah.units,0)
1748: FROM fa_books bk,
1749: fa_deprn_periods dp,
1750: fa_asset_history ah
1751: WHERE dp.book_type_code = p_corp_book
1752: AND bk.book_type_code = dp.book_type_code