[Home] [Help]
610: FROM
611: FA_CATEGORY_BOOKS CB,
612: FA_DISTRIBUTION_HISTORY DH,
613: FA_ASSET_HISTORY AH,
614: FA_DEPRN_DETAIL DD,
615: FA_BOOKS BK -- Added for Member Track
616: WHERE DH.Book_Type_Code = Distribution_Source_Book
617: AND DD.Asset_ID = AH.Asset_ID AND
618: DD.Book_Type_Code = Book AND
619: DD.Distribution_ID = DH.Distribution_ID AND
620: DD.Period_Counter <= Period1_Pc - 1 AND
621: DD.Period_Counter =
622: (SELECT MAX (SUB_DD.Period_Counter)
623: FROM FA_DEPRN_DETAIL SUB_DD
624: WHERE SUB_DD.Asset_ID = DH.Asset_ID AND
625: SUB_DD.Book_Type_Code = Book AND
626: SUB_DD.Distribution_ID = DH.Distribution_ID AND
627: SUB_DD.Period_Counter <= Period1_Pc - 1)
687: FROM
688: FA_CATEGORY_BOOKS CB,
689: FA_DISTRIBUTION_HISTORY DH,
690: FA_ASSET_HISTORY AH,
691: FA_DEPRN_DETAIL DD,
692: FA_BOOKS BK,
693: FA_DEPRN_PERIODS DP_BROW
694: WHERE DH.Book_Type_Code = distribution_source_book
695: AND DD.Asset_ID = AH.Asset_ID AND
757: FROM
758: FA_CATEGORY_BOOKS CB,
759: FA_DISTRIBUTION_HISTORY DH,
760: FA_ASSET_HISTORY AH,
761: FA_DEPRN_DETAIL DD,
762: FA_BOOKS BK
763: WHERE DH.Book_Type_Code = Distribution_Source_Book
764: AND DD.Asset_ID = AH.Asset_ID AND
765: DD.Book_Type_Code = Book AND
766: DD.Distribution_ID = DH.Distribution_ID AND
767: DD.Period_Counter <= period2_pc AND
768: DD.Period_Counter =
769: (SELECT MAX (SUB_DD.Period_Counter)
770: FROM FA_DEPRN_DETAIL SUB_DD
771: WHERE SUB_DD.Asset_ID = DH.Asset_ID AND
772: SUB_DD.Book_Type_Code = Book AND
773: SUB_DD.Distribution_ID = DH.Distribution_ID AND
774: SUB_DD.Period_Counter <= period2_pc)
935: FROM FA_LOOKUPS RT,
936: FA_CATEGORY_BOOKS CB,
937: FA_DISTRIBUTION_HISTORY DH,
938: FA_ASSET_HISTORY AH,
939: FA_DEPRN_DETAIL DD,
940: FA_DEPRN_PERIODS DP,
941: FA_BOOKS BK -- Added for Drill Down Report
942: WHERE DH.Book_Type_Code = Distribution_Source_Book
943: AND AH.Asset_ID = DH.Asset_ID