676: DD.DEPRN_RESERVE RESERVE,
677: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
678: DH.UNITS_ASSIGNED UNITS
679: FROM
680: FA_DEPRN_DETAIL DD,
681: FA_DISTRIBUTION_HISTORY DH,
682: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
683: WHERE
684: DD.ASSET_ID = h_asset_id AND
685: DD.BOOK_TYPE_CODE = h_book AND
686: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
687: DD.PERIOD_COUNTER =
688: (SELECT MAX(DD2.PERIOD_COUNTER)
689: FROM FA_DEPRN_DETAIL DD2
690: WHERE DD2.BOOK_TYPE_CODE = h_book
691: AND DD2.ASSET_ID = h_asset_id
692: AND DD2.DISTRIBUTION_ID = DD.DISTRIBUTION_ID
693: AND DD2.PERIOD_COUNTER <= upc)
708: 0 RESERVE,
709: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
710: 0 UNITS
711: FROM
712: FA_DEPRN_DETAIL DD,
713: FA_DISTRIBUTION_HISTORY DH,
714: FA_DISTRIBUTION_HISTORY DH_PRIOR,
715: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
716: WHERE
719: DD.DISTRIBUTION_ID = DH_PRIOR.DISTRIBUTION_ID AND
720: DH.CODE_COMBINATION_ID = DH_PRIOR.CODE_COMBINATION_ID AND /* Added for Bug 12996138 */
721: DD.PERIOD_COUNTER =
722: (SELECT MAX(DD2.PERIOD_COUNTER)
723: FROM FA_DEPRN_DETAIL DD2
724: WHERE DD2.BOOK_TYPE_CODE = h_book
725: AND DD2.ASSET_ID = h_asset_id
726: AND DD2.DISTRIBUTION_ID = DD.DISTRIBUTION_ID
727: AND DD2.PERIOD_COUNTER <= upc)
782: DH.DATE_EFFECTIVE <= ucd AND
783: nvl(DH.DATE_INEFFECTIVE, ucd+1) > ucd AND
784: (DH.ASSIGNED_to = h_assigned_to OR
785: (DH.ASSIGNED_TO is null and h_assigned_to is null)) AND
786: (NOT EXISTS (SELECT 1 FROM FA_DEPRN_DETAIL DD
787: WHERE DD.ASSET_ID = h_asset_id
788: AND DD.BOOK_TYPE_CODE = h_book
789: AND DD.PERIOD_COUNTER = upc)));
790: else/* else */
805: DD.DEPRN_RESERVE RESERVE,
806: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
807: DH.UNITS_ASSIGNED UNITS
808: FROM
809: FA_DEPRN_DETAIL_mrc_v DD,
810: FA_DISTRIBUTION_HISTORY DH,
811: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
812: WHERE
813: DD.ASSET_ID = h_asset_id AND
814: DD.BOOK_TYPE_CODE = h_book AND
815: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
816: DD.PERIOD_COUNTER =
817: (SELECT MAX(DD2.PERIOD_COUNTER)
818: FROM FA_DEPRN_DETAIL_mrc_v DD2
819: WHERE DD2.BOOK_TYPE_CODE = h_book
820: AND DD2.ASSET_ID = h_asset_id
821: AND DD2.DISTRIBUTION_ID = DD.DISTRIBUTION_ID
822: AND DD2.PERIOD_COUNTER <= upc)
837: 0 RESERVE,
838: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
839: 0 UNITS
840: FROM
841: FA_DEPRN_DETAIL_mrc_v DD,
842: FA_DISTRIBUTION_HISTORY DH,
843: FA_DISTRIBUTION_HISTORY DH_PRIOR,
844: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
845: WHERE
848: DD.DISTRIBUTION_ID = DH_PRIOR.DISTRIBUTION_ID AND
849: DH.CODE_COMBINATION_ID = DH_PRIOR.CODE_COMBINATION_ID AND /* Added for Bug 12996138 */
850: DD.PERIOD_COUNTER =
851: (SELECT MAX(DD2.PERIOD_COUNTER)
852: FROM FA_DEPRN_DETAIL_mrc_v DD2
853: WHERE DD2.BOOK_TYPE_CODE = h_book
854: AND DD2.ASSET_ID = h_asset_id
855: AND DD2.DISTRIBUTION_ID = DD.DISTRIBUTION_ID
856: AND DD2.PERIOD_COUNTER <= upc)
911: DH.DATE_EFFECTIVE <= ucd AND
912: nvl(DH.DATE_INEFFECTIVE, ucd+1) > ucd AND
913: (DH.ASSIGNED_to = h_assigned_to OR
914: (DH.ASSIGNED_TO is null and h_assigned_to is null)) AND
915: (NOT EXISTS (SELECT 1 FROM FA_DEPRN_DETAIL_mrc_v DD
916: WHERE DD.ASSET_ID = h_asset_id
917: AND DD.BOOK_TYPE_CODE = h_book
918: AND DD.PERIOD_COUNTER = upc)));
919: END if;