[Home] [Help]
200: aj.adjustment_amount),
201: h_request_id
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
242: aj.adjustment_amount),
243: h_request_id
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,
311: aj.adjustment_amount),
312: h_request_id
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
355: aj.adjustment_amount),
356: h_request_id
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,
429: aj.adjustment_amount),
430: h_request_id
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
481: aj.adjustment_amount),
482: h_request_id
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,
559: aj.adjustment_amount),
560: h_request_id
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
612: aj.adjustment_amount),
613: h_request_id
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,
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
701: FROM fa_balances_reports_itf
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
744: (SELECT asset_id
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
1180: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
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,
1287: (SELECT asset_id,
1288: distribution_id,
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
1393: WHERE dh.book_type_code = distribution_source_book
1394: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
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
1495: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
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
1602: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
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
1760: fa_group_asset_default gad
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
1872: fa_group_asset_default gad
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
2116: fa_group_asset_default gad
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
2225: fa_group_asset_default gad
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,
2438: fa_adjustments_mrc_v adj
2439: WHERE dh.book_type_code = distribution_source_book
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,
2519: fa_adjustments adj
2520: WHERE dh.book_type_code = distribution_source_book