1107: UCD
1108: FROM FA_DEPRN_SUMMARY_MRC_V DD,
1109: fa_GROUP_ASSET_RULES GAR,
1110: fa_GROUP_ASSET_DEFAULT GAD,
1111: fa_SUPER_GROUP_RULES SGR,
1112: FA_DEPRN_PERIODS_MRC_V DP
1113: WHERE DD.BOOK_TYPE_CODE = book
1114: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1115: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1170: UCD
1171: FROM FA_DEPRN_SUMMARY DD,
1172: fa_GROUP_ASSET_RULES GAR,
1173: fa_GROUP_ASSET_DEFAULT GAD,
1174: fa_SUPER_GROUP_RULES SGR,
1175: FA_DEPRN_PERIODS DP
1176: WHERE DD.BOOK_TYPE_CODE = book
1177: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1178: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE