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_DETAIL_MRC_V

Line 698: fa_deprn_detail_mrc_v dd

694: h_request_id
695: FROM fa_distribution_history dh,
696: fa_category_books cb,
697: fa_asset_history ah,
698: fa_deprn_detail_mrc_v dd
699: WHERE NOT EXISTS
700: (SELECT asset_id
701: FROM fa_balances_reports_itf
702: WHERE asset_id = dh.asset_id

Line 1175: fa_deprn_detail_mrc_v dd,

1171: 'REVAL RESERVE',
1172: dd.reval_reserve),
1173: h_request_id
1174: FROM fa_distribution_history dh,
1175: fa_deprn_detail_mrc_v dd,
1176: fa_asset_history ah,
1177: fa_category_books cb,
1178: fa_books_mrc_v bk
1179: WHERE dh.book_type_code = distribution_source_book

Line 1202: FROM fa_deprn_detail_mrc_v sub_dd

1198: DD.Deprn_Source_Code AND */
1199: -- End bug fix 5076193
1200: dd.period_counter =
1201: (SELECT MAX(sub_dd.period_counter)
1202: FROM fa_deprn_detail_mrc_v sub_dd
1203: WHERE sub_dd.book_type_code = book
1204: AND sub_dd.distribution_id = dh.distribution_id
1205: AND dh.distribution_id = dd.distribution_id
1206: AND sub_dd.period_counter <= period_pc)

Line 1490: fa_deprn_detail_mrc_v dd,

1486: 'REVAL RESERVE',
1487: dd.reval_reserve),
1488: h_request_id
1489: FROM fa_distribution_history dh,
1490: fa_deprn_detail_mrc_v dd,
1491: fa_asset_history ah,
1492: fa_category_books cb,
1493: fa_books_mrc_v bk
1494: WHERE dh.book_type_code = distribution_source_book

Line 1518: FROM fa_deprn_detail_mrc_v sub_dd

1514: DD.Deprn_Source_Code AND */
1515: -- end bug fix 5076193
1516: dd.period_counter =
1517: (SELECT MAX(sub_dd.period_counter)
1518: FROM fa_deprn_detail_mrc_v sub_dd
1519: WHERE sub_dd.book_type_code = book
1520: AND sub_dd.distribution_id = dh.distribution_id
1521: AND dh.distribution_id = dd.distribution_id
1522: AND sub_dd.period_counter <= period_pc)

Line 1757: fa_deprn_detail_mrc_v dd,

1753: h_request_id
1754: FROM fa_books_mrc_v bk,
1755: fa_category_books cb,
1756: fa_asset_history ah,
1757: fa_deprn_detail_mrc_v dd,
1758: fa_distribution_history dh,
1759: -- Commented by Prabakar
1760: fa_group_asset_default gad
1761: WHERE

Line 1780: FROM fa_deprn_detail_mrc_v sub_dd

1776: AND decode(begin_or_end, 'BEGIN', dd.deprn_source_code, 'D') =
1777: dd.deprn_source_code
1778: AND dd.period_counter =
1779: (SELECT MAX(sub_dd.period_counter)
1780: FROM fa_deprn_detail_mrc_v sub_dd
1781: WHERE sub_dd.book_type_code = book
1782: AND sub_dd.distribution_id = dh.distribution_id
1783: AND sub_dd.period_counter <= period_pc)
1784: AND ah.asset_id = dd.asset_id

Line 1975: FROM fa_deprn_detail_mrc_v dd_sub

1971: AND gad.group_asset_id = gar.group_asset_id
1972: AND dd.asset_id BETWEEN start_range AND end_range --Anuj
1973: AND dd.period_counter =
1974: (SELECT MAX(dd_sub.period_counter)
1975: FROM fa_deprn_detail_mrc_v dd_sub
1976: WHERE dd_sub.book_type_code = book
1977: AND dd_sub.asset_id = gar.group_asset_id
1978: AND dd_sub.period_counter <= period_pc);
1979: ELSE

Line 2113: fa_deprn_detail_mrc_v dd,

2109: h_request_id
2110: FROM fa_books_mrc_v bk,
2111: fa_category_books cb,
2112: fa_asset_history ah,
2113: fa_deprn_detail_mrc_v dd,
2114: fa_distribution_history dh,
2115: -- Commented by Prabakar
2116: fa_group_asset_default gad
2117: WHERE

Line 2135: FROM fa_deprn_detail_mrc_v sub_dd

2131: AND decode(begin_or_end, 'BEGIN', dd.deprn_source_code, 'D') =
2132: dd.deprn_source_code
2133: AND dd.period_counter =
2134: (SELECT MAX(sub_dd.period_counter)
2135: FROM fa_deprn_detail_mrc_v sub_dd
2136: WHERE sub_dd.book_type_code = book
2137: AND sub_dd.distribution_id = dh.distribution_id
2138: AND sub_dd.period_counter <= period_pc)
2139: AND ah.asset_id = dd.asset_id

Line 2325: FROM fa_deprn_detail_mrc_v dd_sub

2321: AND gad.book_type_code = gar.book_type_code
2322: AND gad.group_asset_id = gar.group_asset_id
2323: AND dd.period_counter =
2324: (SELECT MAX(dd_sub.period_counter)
2325: FROM fa_deprn_detail_mrc_v dd_sub
2326: WHERE dd_sub.book_type_code = book
2327: AND dd_sub.asset_id = gar.group_asset_id
2328: AND dd_sub.period_counter <= period_pc);
2329: ELSE

Line 2436: fa_deprn_detail_mrc_v dd,

2432: h_request_id
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