VIEW: APPS.OKX_AST_DPRTNS_V

Source

View Text - Preformatted

SELECT fadep.Asset_id ID1, fadep.Book_Type_Code||','||to_char(fadep.period_counter) ID2, fa.asset_number NAME, fa.Asset_number||','||fadep.Book_Type_Code||','||to_char(fadep.period_counter) DESCRIPTION, fadep.BOOK_TYPE_CODE BOOK_TYPE_CODE, fadep.ASSET_ID ASSET_ID, fadep.DEPRN_RUN_DATE DEPRN_RUN_DATE, fadep.DEPRN_AMOUNT DEPRN_AMOUNT, fadep.YTD_DEPRN YTD_DEPRN, fadep.DEPRN_RESERVE DEPRN_RESERVE, fadep.DEPRN_SOURCE_CODE DEPRN_SOURCE_CODE, fadep.ADJUSTED_COST ADJUSTED_COST, fadep.BONUS_RATE BONUS_RATE, fadep.LTD_PRODUCTION LTD_PRODUCTION, fadep.PERIOD_COUNTER PERIOD_COUNTER, fadep.PRODUCTION PRODUCTION, fadep.REVAL_AMORTIZATION REVAL_AMORTIZATION, fadep.REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS, fadep.REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE, fadep.REVAL_RESERVE REVAL_RESERVE, fadep.YTD_PRODUCTION YTD_PRODUCTION, fadep.YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE, fadep.PRIOR_FY_EXPENSE PRIOR_FY_EXPENSE, fadep.BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT, fadep.BONUS_YTD_DEPRN BONUS_YTD_DEPRN, fadep.BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE, fadep.PRIOR_FY_BONUS_EXPENSE PRIOR_FY_BONUS_EXPENSE, sysdate START_DATE_ACTIVE, sysdate+1 END_DATE_ACTIVE, 'A' STATUS, NULL PRIMARY_UOM_CODE FROM FA_DEPRN_SUMMARY FADEP,FA_ADDITIONS_B FA WHERE FADEP.ASSET_ID = FA.ASSET_ID

View Text - HTML Formatted

SELECT FADEP.ASSET_ID ID1
, FADEP.BOOK_TYPE_CODE||'
, '||TO_CHAR(FADEP.PERIOD_COUNTER) ID2
, FA.ASSET_NUMBER NAME
, FA.ASSET_NUMBER||'
, '||FADEP.BOOK_TYPE_CODE||'
, '||TO_CHAR(FADEP.PERIOD_COUNTER) DESCRIPTION
, FADEP.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FADEP.ASSET_ID ASSET_ID
, FADEP.DEPRN_RUN_DATE DEPRN_RUN_DATE
, FADEP.DEPRN_AMOUNT DEPRN_AMOUNT
, FADEP.YTD_DEPRN YTD_DEPRN
, FADEP.DEPRN_RESERVE DEPRN_RESERVE
, FADEP.DEPRN_SOURCE_CODE DEPRN_SOURCE_CODE
, FADEP.ADJUSTED_COST ADJUSTED_COST
, FADEP.BONUS_RATE BONUS_RATE
, FADEP.LTD_PRODUCTION LTD_PRODUCTION
, FADEP.PERIOD_COUNTER PERIOD_COUNTER
, FADEP.PRODUCTION PRODUCTION
, FADEP.REVAL_AMORTIZATION REVAL_AMORTIZATION
, FADEP.REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS
, FADEP.REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE
, FADEP.REVAL_RESERVE REVAL_RESERVE
, FADEP.YTD_PRODUCTION YTD_PRODUCTION
, FADEP.YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE
, FADEP.PRIOR_FY_EXPENSE PRIOR_FY_EXPENSE
, FADEP.BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT
, FADEP.BONUS_YTD_DEPRN BONUS_YTD_DEPRN
, FADEP.BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE
, FADEP.PRIOR_FY_BONUS_EXPENSE PRIOR_FY_BONUS_EXPENSE
, SYSDATE START_DATE_ACTIVE
, SYSDATE+1 END_DATE_ACTIVE
, 'A' STATUS
, NULL PRIMARY_UOM_CODE
FROM FA_DEPRN_SUMMARY FADEP
, FA_ADDITIONS_B FA
WHERE FADEP.ASSET_ID = FA.ASSET_ID