436: ''
437: FROM
438: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
439: FA_ASSET_HISTORY AH,
440: FA_TRANSACTION_HEADERS TH,
441: FA_TRANSACTION_HEADERS TH_RT,
442: FA_BOOKS_MRC_V BOOKS,
443: FA_DISTRIBUTION_HISTORY DH,
444: FA_CATEGORY_BOOKS CB
437: FROM
438: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
439: FA_ASSET_HISTORY AH,
440: FA_TRANSACTION_HEADERS TH,
441: FA_TRANSACTION_HEADERS TH_RT,
442: FA_BOOKS_MRC_V BOOKS,
443: FA_DISTRIBUTION_HISTORY DH,
444: FA_CATEGORY_BOOKS CB
445: WHERE
501: CB.BONUS_DEPRN_EXPENSE_ACCT
502: FROM
503: FA_DEPRN_DETAIL_MRC_V DD,
504: FA_ASSET_HISTORY AH,
505: FA_TRANSACTION_HEADERS TH,
506: FA_TRANSACTION_HEADERS TH_RT,
507: FA_BOOKS_MRC_V BOOKS,
508: FA_DISTRIBUTION_HISTORY DH,
509: FA_CATEGORY_BOOKS CB
502: FROM
503: FA_DEPRN_DETAIL_MRC_V DD,
504: FA_ASSET_HISTORY AH,
505: FA_TRANSACTION_HEADERS TH,
506: FA_TRANSACTION_HEADERS TH_RT,
507: FA_BOOKS_MRC_V BOOKS,
508: FA_DISTRIBUTION_HISTORY DH,
509: FA_CATEGORY_BOOKS CB
510: WHERE
593: ''
594: FROM
595: FA_DEPRN_DETAIL DD_BONUS,
596: FA_ASSET_HISTORY AH,
597: FA_TRANSACTION_HEADERS TH,
598: FA_TRANSACTION_HEADERS TH_RT,
599: FA_BOOKS BOOKS,
600: FA_DISTRIBUTION_HISTORY DH,
601: FA_CATEGORY_BOOKS CB
594: FROM
595: FA_DEPRN_DETAIL DD_BONUS,
596: FA_ASSET_HISTORY AH,
597: FA_TRANSACTION_HEADERS TH,
598: FA_TRANSACTION_HEADERS TH_RT,
599: FA_BOOKS BOOKS,
600: FA_DISTRIBUTION_HISTORY DH,
601: FA_CATEGORY_BOOKS CB
602: WHERE
658: CB.BONUS_DEPRN_EXPENSE_ACCT
659: FROM
660: FA_DEPRN_DETAIL DD,
661: FA_ASSET_HISTORY AH,
662: FA_TRANSACTION_HEADERS TH,
663: FA_TRANSACTION_HEADERS TH_RT,
664: FA_BOOKS BOOKS,
665: FA_DISTRIBUTION_HISTORY DH,
666: FA_CATEGORY_BOOKS CB
659: FROM
660: FA_DEPRN_DETAIL DD,
661: FA_ASSET_HISTORY AH,
662: FA_TRANSACTION_HEADERS TH,
663: FA_TRANSACTION_HEADERS TH_RT,
664: FA_BOOKS BOOKS,
665: FA_DISTRIBUTION_HISTORY DH,
666: FA_CATEGORY_BOOKS CB
667: WHERE
753: NVL(TH.DATE_EFFECTIVE, ucd)
754: FROM
755: FA_DEPRN_DETAIL_MRC_V DD,
756: FA_ASSET_HISTORY AH,
757: FA_TRANSACTION_HEADERS TH,
758: FA_TRANSACTION_HEADERS TH_RT,
759: FA_BOOKS_MRC_V BOOKS,
760: FA_DISTRIBUTION_HISTORY DH,
761: FA_CATEGORY_BOOKS CB
754: FROM
755: FA_DEPRN_DETAIL_MRC_V DD,
756: FA_ASSET_HISTORY AH,
757: FA_TRANSACTION_HEADERS TH,
758: FA_TRANSACTION_HEADERS TH_RT,
759: FA_BOOKS_MRC_V BOOKS,
760: FA_DISTRIBUTION_HISTORY DH,
761: FA_CATEGORY_BOOKS CB
762: WHERE
847: NVL(TH.DATE_EFFECTIVE, ucd)
848: FROM
849: FA_DEPRN_DETAIL DD,
850: FA_ASSET_HISTORY AH,
851: FA_TRANSACTION_HEADERS TH,
852: FA_TRANSACTION_HEADERS TH_RT,
853: FA_BOOKS BOOKS,
854: FA_DISTRIBUTION_HISTORY DH,
855: FA_CATEGORY_BOOKS CB
848: FROM
849: FA_DEPRN_DETAIL DD,
850: FA_ASSET_HISTORY AH,
851: FA_TRANSACTION_HEADERS TH,
852: FA_TRANSACTION_HEADERS TH_RT,
853: FA_BOOKS BOOKS,
854: FA_DISTRIBUTION_HISTORY DH,
855: FA_CATEGORY_BOOKS CB
856: WHERE