435: NVL(TH.DATE_EFFECTIVE, ucd),
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,
500: NVL(TH.DATE_EFFECTIVE, ucd),
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,
592: NVL(TH.DATE_EFFECTIVE, ucd),
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,
657: NVL(TH.DATE_EFFECTIVE, ucd),
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,
752: DD.PERIOD_COUNTER,
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,
846: DD.PERIOD_COUNTER,
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,