[Home] [Help]
198: aj.source_type_code,
199: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
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
240: aj.source_type_code,
241: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
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
309: aj.source_type_code,
310: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
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
353: aj.source_type_code,
354: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
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
427: aj.source_type_code,
428: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
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
479: aj.source_type_code,
480: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
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
557: aj.source_type_code,
558: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
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
610: aj.source_type_code,
611: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
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
691: cb.deprn_reserve_acct,
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
734: cb.deprn_reserve_acct,
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
1170: dd.deprn_reserve,
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
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,
1287: (SELECT asset_id,
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
1393: WHERE dh.book_type_code = distribution_source_book
1485: dd.deprn_reserve,
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
1592: dd.deprn_reserve,
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
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
1762: -- Commented by Prabakar
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
1874: -- Commented by Prabakar
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
2118: -- Commented by Prabakar
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
2227: -- Commented by Prabakar
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,
2438: fa_adjustments_mrc_v adj
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,
2519: fa_adjustments adj