[Home] [Help]
692: 'ADDITION',
693: SUM(dd.deprn_reserve),
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
735: 'ADDITION',
736: SUM(nvl(dd.deprn_reserve, 0)),
737: h_request_id
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
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
1180: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
1181: dh.date_effective AND nvl(dh.date_ineffective, SYSDATE)
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,
1287: (SELECT asset_id,
1288: distribution_id,
1289: MAX(period_counter) mpc
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
1393: WHERE dh.book_type_code = distribution_source_book
1394: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
1395: dh.date_effective AND nvl(dh.date_ineffective, SYSDATE)
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
1495: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
1496: dh.date_effective AND nvl(dh.date_ineffective, SYSDATE)
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
1602: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
1603: dh.date_effective AND nvl(dh.date_ineffective, SYSDATE)
1751: 'REVAL RESERVE',
1752: dd.reval_reserve),
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
1863: 'REVAL RESERVE',
1864: dd.reval_reserve),
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
2107: 'REVAL RESERVE',
2108: dd.reval_reserve),
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
2216: 'REVAL RESERVE',
2217: dd.reval_reserve),
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
2429: nvl(adj.adjustment_amount, 0),
2430: 'REVAL RESERVE',
2431: -dd.reval_amortization)),
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,
2510: 'REVAL RESERVE',
2511: -dd.reval_amortization)),
2512: h_request_id
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,