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_BALREP_PKG dependencies on FA_DEPRN_PERIODS

Line 206: fa_deprn_periods dp

202: FROM fa_distribution_history dh,
203: fa_transaction_headers th,
204: fa_asset_history ah,
205: fa_adjustments_mrc_v aj,
206: fa_deprn_periods dp
207: WHERE dh.book_type_code = distribution_source_book
208: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
209: AND aj.asset_id = dh.asset_id
210: AND aj.book_type_code = book

Line 248: fa_deprn_periods dp

244: FROM fa_distribution_history dh,
245: fa_transaction_headers th,
246: fa_asset_history ah,
247: fa_adjustments_mrc_v aj,
248: fa_deprn_periods dp
249: /* SLA Changes */,
250: xla_ae_headers headers,
251: xla_ae_lines lines,
252: xla_distribution_links links

Line 317: fa_deprn_periods dp

313: FROM fa_distribution_history dh,
314: fa_transaction_headers th,
315: fa_asset_history ah,
316: fa_adjustments aj,
317: fa_deprn_periods dp
318: WHERE dh.book_type_code = distribution_source_book
319: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
320: AND aj.asset_id = dh.asset_id
321: AND aj.book_type_code = book

Line 361: fa_deprn_periods dp

357: FROM fa_distribution_history dh,
358: fa_transaction_headers th,
359: fa_asset_history ah,
360: fa_adjustments aj,
361: fa_deprn_periods dp
362: /* SLA Changes */,
363: xla_ae_headers headers,
364: xla_ae_lines lines,
365: xla_distribution_links links

Line 435: fa_deprn_periods dp

431: FROM fa_distribution_history dh,
432: fa_transaction_headers th,
433: fa_asset_history ah,
434: fa_adjustments_mrc_v aj,
435: fa_deprn_periods dp
436: WHERE dh.book_type_code = distribution_source_book
437: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
438: AND aj.asset_id = dh.asset_id
439: AND aj.book_type_code = book

Line 487: fa_deprn_periods dp

483: FROM fa_distribution_history dh,
484: fa_transaction_headers th,
485: fa_asset_history ah,
486: fa_adjustments_mrc_v aj,
487: fa_deprn_periods dp
488: /* SLA Changes */,
489: xla_ae_headers headers,
490: xla_ae_lines lines,
491: xla_distribution_links links

Line 565: fa_deprn_periods dp

561: FROM fa_distribution_history dh,
562: fa_transaction_headers th,
563: fa_asset_history ah,
564: fa_adjustments aj,
565: fa_deprn_periods dp
566:
567: WHERE dh.book_type_code = distribution_source_book
568: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
569: AND aj.asset_id = dh.asset_id

Line 618: fa_deprn_periods dp

614: FROM fa_distribution_history dh,
615: fa_transaction_headers th,
616: fa_asset_history ah,
617: fa_adjustments aj,
618: fa_deprn_periods dp
619: /* SLA Changes */,
620: xla_ae_headers headers,
621: xla_ae_lines lines,
622: xla_distribution_links links

Line 848: fa_deprn_periods dp

844: h_request_id
845: FROM fa_adjustments_mrc_v aj,
846: fa_books_mrc_v bk,
847: fa_group_asset_default gad,
848: fa_deprn_periods dp
849: WHERE bk.asset_id = aj.asset_id
850: AND bk.book_type_code = book
851: AND bk.group_asset_id = gad.group_asset_id
852: AND bk.book_type_code = gad.book_type_code

Line 898: fa_deprn_periods dp

894: h_request_id
895: FROM fa_adjustments_mrc_v aj,
896: fa_books_mrc_v bk,
897: fa_group_asset_default gad,
898: fa_deprn_periods dp
899: /* SLA Changes */,
900: xla_ae_headers headers,
901: xla_ae_lines lines,
902: xla_distribution_links links

Line 973: fa_deprn_periods dp

969: h_request_id
970: FROM fa_adjustments aj,
971: fa_books bk,
972: fa_group_asset_default gad,
973: fa_deprn_periods dp
974: WHERE bk.asset_id = aj.asset_id
975: AND bk.book_type_code = book
976: AND aj.asset_id BETWEEN start_range AND end_range --anuj
977: AND bk.group_asset_id = gad.group_asset_id

Line 1023: fa_deprn_periods dp

1019: h_request_id
1020: FROM fa_adjustments aj,
1021: fa_books bk,
1022: fa_group_asset_default gad,
1023: fa_deprn_periods dp
1024:
1025: /* SLA Changes */,
1026: xla_ae_headers headers,
1027: xla_ae_lines lines,

Line 2437: fa_deprn_periods_mrc_v dp,

2433: FROM fa_category_books cb,
2434: fa_distribution_history dh,
2435: fa_asset_history ah,
2436: fa_deprn_detail_mrc_v dd,
2437: fa_deprn_periods_mrc_v dp,
2438: fa_adjustments_mrc_v adj
2439: WHERE dh.book_type_code = distribution_source_book
2440: AND ah.asset_id = dd.asset_id
2441: AND ah.asset_type IN ('CAPITALIZED', 'CIP')

Line 2518: fa_deprn_periods dp,

2514: fa_category_books cb,
2515: fa_distribution_history dh,
2516: fa_asset_history ah,
2517: fa_deprn_detail dd,
2518: fa_deprn_periods dp,
2519: fa_adjustments adj
2520: WHERE dh.book_type_code = distribution_source_book
2521: AND ah.asset_id = dd.asset_id
2522: AND ah.asset_type IN ('CAPITALIZED', 'CIP')

Line 2705: FROM fa_deprn_periods

2701: END IF;
2702:
2703: SELECT period_open_date, nvl(period_close_date, SYSDATE)
2704: INTO beg_period_open_date, beg_period_close_date
2705: FROM fa_deprn_periods
2706: WHERE book_type_code = book
2707: AND period_counter = period1_pc;
2708:
2709: get_balance(book,

Line 2741: FROM fa_deprn_periods

2737: END IF;
2738:
2739: SELECT period_open_date, nvl(period_close_date, SYSDATE)
2740: INTO end_period_open_date, end_period_close_date
2741: FROM fa_deprn_periods
2742: WHERE book_type_code = book
2743: AND period_counter = period2_pc;
2744:
2745: -- Get Ending Balance