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

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 742: fa_deprn_detail dd

738: FROM fa_distribution_history dh,
739: fa_category_books cb,
740: fa_asset_history ah,
741: fa_book_controls bc,
742: fa_deprn_detail dd
743: WHERE NOT EXISTS
744: (SELECT asset_id
745: FROM fa_balances_reports_itf
746: 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 1282: FROM fa_deprn_detail dd,

1278: dd.deprn_reserve,
1279: 'REVAL RESERVE',
1280: dd.reval_reserve),
1281: h_request_id
1282: FROM fa_deprn_detail dd,
1283: fa_distribution_history dh,
1284: fa_asset_history ah,
1285: fa_category_books cb,
1286: fa_books bk,

Line 1290: FROM fa_deprn_detail

1286: fa_books bk,
1287: (SELECT asset_id,
1288: distribution_id,
1289: MAX(period_counter) mpc
1290: FROM fa_deprn_detail
1291: WHERE book_type_code = book
1292: AND period_counter <= period_pc
1293: GROUP BY asset_id, distribution_id) sub_dd
1294: WHERE dh.book_type_code = distribution_source_book

Line 1388: FROM fa_deprn_detail dd,

1384: dd.deprn_reserve,
1385: 'REVAL RESERVE',
1386: dd.reval_reserve),
1387: h_request_id
1388: FROM fa_deprn_detail dd,
1389: fa_distribution_history dh,
1390: fa_asset_history ah,
1391: fa_category_books cb,
1392: fa_books bk

Line 1405: FROM fa_deprn_detail sub_dd

1401: AND decode(begin_or_end, 'BEGIN', dd.deprn_source_code, 'D') =
1402: dd.deprn_source_code
1403: AND dd.period_counter =
1404: (SELECT MAX(sub_dd.period_counter)
1405: FROM fa_deprn_detail sub_dd
1406: WHERE sub_dd.book_type_code = book
1407: AND sub_dd.distribution_id = dh.distribution_id
1408: AND dh.distribution_id = dd.distribution_id
1409: 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 1597: fa_deprn_detail dd,

1593: 'REVAL RESERVE',
1594: dd.reval_reserve),
1595: h_request_id
1596: FROM fa_distribution_history dh,
1597: fa_deprn_detail dd,
1598: fa_asset_history ah,
1599: fa_category_books cb,
1600: fa_books bk
1601: WHERE dh.book_type_code = distribution_source_book

Line 1625: FROM fa_deprn_detail sub_dd

1621: DD.Deprn_Source_Code AND */
1622: -- End bug fix 5076193
1623: dd.period_counter =
1624: (SELECT MAX(sub_dd.period_counter)
1625: FROM fa_deprn_detail sub_dd
1626: WHERE sub_dd.book_type_code = book
1627: AND sub_dd.distribution_id = dh.distribution_id
1628: AND dh.distribution_id = dd.distribution_id
1629: 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 1869: fa_deprn_detail dd,

1865: h_request_id
1866: FROM fa_books bk,
1867: fa_category_books cb,
1868: fa_asset_history ah,
1869: fa_deprn_detail dd,
1870: fa_distribution_history dh,
1871: -- Commented by Prabakar
1872: fa_group_asset_default gad
1873: WHERE

Line 1892: FROM fa_deprn_detail sub_dd

1888: AND decode(begin_or_end, 'BEGIN', dd.deprn_source_code, 'D') =
1889: dd.deprn_source_code
1890: AND dd.period_counter =
1891: (SELECT MAX(sub_dd.period_counter)
1892: FROM fa_deprn_detail sub_dd
1893: WHERE sub_dd.book_type_code = book
1894: AND sub_dd.distribution_id = dh.distribution_id
1895: AND sub_dd.period_counter <= period_pc)
1896: 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 2014: FROM fa_deprn_detail dd_sub

2010: AND gad.book_type_code = gar.book_type_code
2011: AND gad.group_asset_id = gar.group_asset_id
2012: AND dd.period_counter =
2013: (SELECT MAX(dd_sub.period_counter)
2014: FROM fa_deprn_detail dd_sub
2015: WHERE dd_sub.book_type_code = book
2016: AND dd_sub.asset_id = gar.group_asset_id
2017: AND dd_sub.period_counter <= period_pc);
2018: END IF;

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 2222: fa_deprn_detail dd,

2218: h_request_id
2219: FROM fa_books bk,
2220: fa_category_books cb,
2221: fa_asset_history ah,
2222: fa_deprn_detail dd,
2223: fa_distribution_history dh,
2224: -- Commented by Prabakar
2225: fa_group_asset_default gad
2226: WHERE

Line 2244: FROM fa_deprn_detail sub_dd

2240: AND decode(begin_or_end, 'BEGIN', dd.deprn_source_code, 'D') =
2241: dd.deprn_source_code
2242: AND dd.period_counter =
2243: (SELECT MAX(sub_dd.period_counter)
2244: FROM fa_deprn_detail sub_dd
2245: WHERE sub_dd.book_type_code = book
2246: AND sub_dd.distribution_id = dh.distribution_id
2247: AND sub_dd.period_counter <= period_pc)
2248: 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 2363: FROM fa_deprn_detail dd_sub

2359: AND gad.book_type_code = gar.book_type_code
2360: AND gad.group_asset_id = gar.group_asset_id
2361: AND dd.period_counter =
2362: (SELECT MAX(dd_sub.period_counter)
2363: FROM fa_deprn_detail dd_sub
2364: WHERE dd_sub.book_type_code = book
2365: AND dd_sub.asset_id = gar.group_asset_id
2366: AND dd_sub.period_counter <= period_pc);
2367: END IF;

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

Line 2517: fa_deprn_detail dd,

2513: FROM --fa_lookups_b rt, Bug fix 11727910 fa_lookups_b is not used in this report
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