474: FA_LOOKUPS RT,
475: FA_DISTRIBUTION_HISTORY DH,
476: FA_TRANSACTION_HEADERS TH,
477: FA_ASSET_HISTORY AH,
478: FA_ADJUSTMENTS_MRC_V AJ
479:
480: /* SLA Changes */
481: ,xla_ae_headers headers
482: ,xla_ae_lines lines
629: FA_LOOKUPS RT,
630: FA_DISTRIBUTION_HISTORY DH,
631: FA_TRANSACTION_HEADERS TH,
632: FA_ASSET_HISTORY AH,
633: FA_ADJUSTMENTS_MRC_V AJ
634:
635: /* SLA Changes */
636: ,xla_ae_headers headers
637: ,xla_ae_lines lines
932: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
933: AJ.Adjustment_Amount)
934: FROM
935: FA_LOOKUPS RT,
936: FA_ADJUSTMENTS_MRC_V AJ,
937: fa_books_mrc_v bk,
938: fa_group_asset_default gad
939:
940: /* SLA Changes */
2320: FA_DISTRIBUTION_HISTORY DH,
2321: FA_ASSET_HISTORY AH,
2322: FA_DEPRN_DETAIL_MRC_V DD,
2323: FA_DEPRN_PERIODS_MRC_V DP,
2324: FA_ADJUSTMENTS_MRC_V ADJ
2325: WHERE
2326: DH.Book_Type_Code = Distribution_Source_Book
2327: AND
2328: AH.Asset_ID = DH.Asset_ID AND