612: NVL(TH.DATE_EFFECTIVE, ucd),
613: DH.DISTRIBUTION_ID,
614: DD.IMPAIRMENT_RESERVE
615: FROM
616: FA_MC_DEPRN_DETAIL DD,
617: FA_ASSET_HISTORY AH,
618: FA_TRANSACTION_HEADERS TH,
619: FA_TRANSACTION_HEADERS TH_RT,
620: FA_MC_BOOKS BOOKS,
656: DD.BOOK_TYPE_CODE = book AND
657: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
658: DD.PERIOD_COUNTER =
659: (SELECT max (DD_SUB.PERIOD_COUNTER)
660: FROM FA_MC_DEPRN_DETAIL DD_SUB
661: WHERE DD_SUB.BOOK_TYPE_CODE = book
662: AND DD_SUB.ASSET_ID = DH.ASSET_ID
663: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
664: AND DD_SUB.PERIOD_COUNTER <= upc