[Home] [Help]
215: NVL(SUM (DECODE (BAL.Source_Type_Code,
216: 'END', NVL(BAL.Amount,0), NULL)), 0) /*Bug# 9293000 */
217: FROM
218: FA_ASSET_HISTORY AH, /* StatReq */
219: fa_category_books cb,
220: FA_METHODS M, /* StatReq */
221: FA_BOOKS B, /* StatReq */
222: FA_BALANCES_REPORT_GT BAL,
223: FA_ADDITIONS AD,
251: --bug 6668625
252: -- Bug#9384471 Modified for displaying correct category after reclass
253: and ah.transaction_header_id_in = ( select max(ah1.transaction_header_id_in)
254: from fa_asset_history ah1,
255: fa_category_books cb1
256: where ah1.asset_id=ah.asset_id
257: -- and ah1.category_id=ah.category_id Bug#9384471
258: and ah1.asset_type=decode(report_type,'CIP COST','CIP',
259: 'COST','CAPITALIZED',ah1.asset_type)
326: NVL(SUM (DECODE (BAL.Source_Type_Code,
327: 'END', NVL(BAL.Amount,0), NULL)), 0) /*Bug# 9293000 */
328: FROM
329: FA_ASSET_HISTORY AH, /* StatReq */
330: fa_category_books cb,
331: FA_METHODS M, /* StatReq */
332: FA_MC_BOOKS B, /* StatReq */
333: FA_BALANCES_REPORT_GT BAL,
334: FA_ADDITIONS AD,
361: -- Added for bug #5015612
362: --bug 6668625
363: and ah.transaction_header_id_in = ( select max(ah1.transaction_header_id_in)
364: from fa_asset_history ah1,
365: fa_category_books cb1
366: where ah1.asset_id=ah.asset_id
367: -- and ah1.category_id=ah.category_id Bug#9384471
368: and ah1.asset_type=decode(report_type,'CIP COST','CIP',
369: 'COST','CAPITALIZED',ah1.asset_type)
822: nvl( SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) * AJ.Adjustment_Amount),0)
823: ,
824: DD.COST
825: FROM
826: FA_CATEGORY_BOOKS CB,
827: FA_DISTRIBUTION_HISTORY DH,
828: FA_ASSET_HISTORY AH,
829: FA_DEPRN_DETAIL DD,
830: FA_BOOKS BK, -- Added for Member Track
937: 'RESERVE', DD.Deprn_Reserve,
938: 'REVAL RESERVE', DD.Reval_Reserve),
939: DD.COST
940: FROM
941: FA_CATEGORY_BOOKS CB,
942: FA_DISTRIBUTION_HISTORY DH,
943: FA_ASSET_HISTORY AH,
944: FA_DEPRN_DETAIL DD,
945: FA_BOOKS BK,
1007: nvl( SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) * AJ.Adjustment_Amount),0)
1008: ,
1009: DD.COST
1010: FROM
1011: FA_CATEGORY_BOOKS CB,
1012: FA_DISTRIBUTION_HISTORY DH,
1013: FA_ASSET_HISTORY AH,
1014: FA_MC_DEPRN_DETAIL DD,
1015: FA_MC_BOOKS BK, -- Added for Member Track
1127: 'RESERVE', DD.Deprn_Reserve,
1128: 'REVAL RESERVE', DD.Reval_Reserve),
1129: DD.COST
1130: FROM
1131: FA_CATEGORY_BOOKS CB,
1132: FA_DISTRIBUTION_HISTORY DH,
1133: FA_ASSET_HISTORY AH,
1134: FA_MC_DEPRN_DETAIL DD,
1135: FA_MC_BOOKS BK,
1199: 'REVAL RESERVE', DD.Reval_Reserve)
1200: +
1201: nvl( SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) * AJ.Adjustment_Amount),0)
1202: FROM
1203: FA_CATEGORY_BOOKS CB,
1204: FA_DISTRIBUTION_HISTORY DH,
1205: FA_ASSET_HISTORY AH,
1206: FA_DEPRN_DETAIL DD,
1207: FA_BOOKS BK,
1322: 'REVAL RESERVE', DD.Reval_Reserve)
1323: +
1324: nvl( SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) * AJ.Adjustment_Amount),0)
1325: FROM
1326: FA_CATEGORY_BOOKS CB,
1327: FA_DISTRIBUTION_HISTORY DH,
1328: FA_ASSET_HISTORY AH,
1329: FA_MC_DEPRN_DETAIL DD,
1330: FA_MC_BOOKS BK,
1443: AJ.Source_Type_Code,
1444: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
1445: AJ.Adjustment_Amount)
1446: FROM
1447: FA_CATEGORY_BOOKS CB,
1448: FA_ASSET_HISTORY AH1,
1449: FA_DISTRIBUTION_HISTORY DH,
1450: FA_TRANSACTION_HEADERS TH,
1451: FA_ASSET_HISTORY AH,
1538: AJ.Source_Type_Code,
1539: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
1540: AJ.Adjustment_Amount)
1541: FROM
1542: FA_CATEGORY_BOOKS CB,
1543: FA_ASSET_HISTORY AH1,
1544: FA_DISTRIBUTION_HISTORY DH,
1545: FA_TRANSACTION_HEADERS TH,
1546: FA_ASSET_HISTORY AH,
1641: SUM (DECODE (Report_Type,
1642: 'RESERVE', DD.Deprn_Amount,
1643: 'REVAL RESERVE', -DD.Reval_Amortization))
1644: FROM
1645: FA_CATEGORY_BOOKS CB,
1646: FA_DISTRIBUTION_HISTORY DH,
1647: FA_ASSET_HISTORY AH,
1648: FA_DEPRN_DETAIL DD,
1649: FA_DEPRN_PERIODS DP,
1713: SUM (DECODE (Report_Type,
1714: 'RESERVE', DD.Deprn_Amount,
1715: 'REVAL RESERVE', -DD.Reval_Amortization))
1716: FROM
1717: FA_CATEGORY_BOOKS CB,
1718: FA_DISTRIBUTION_HISTORY DH,
1719: FA_ASSET_HISTORY AH,
1720: FA_MC_DEPRN_DETAIL DD,
1721: FA_MC_DEPRN_PERIODS DP,
1823:
1824: -- Each FA_BALANCES_REPORT_GT row corresponds to one of the following:
1825: -- (1) begin balance, (2) end balance, (3) an adjustment, (4)
1826: -- depreciation. Each corresponds to a given account. Sometimes,
1827: -- the account is the default from FA_CATEGORY_BOOKS; in this case
1828: -- the account segment itself is stored here and we can simply select
1829: -- it later. However, sometimes the "account" is stored as a ccid.
1830: -- In this case, we must find the accounting segment corresponding
1831: -- to that ccid, and store it now, so we can select it later.