VIEW: FA.FA_DEPRN_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, ASSET_NUMBER ASSET_NUMBER, DESCRIPTION DESCRIPTION, SERIAL_NUMBER SERIAL_NUMBER, TAG_NUMBER TAG_NUMBER, CATEGORY CATEGORY, UNITS UNITS, EMPLOYEE_NAME EMPLOYEE_NAME, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, LOCATION LOCATION, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, DEPRN_METHOD DEPRN_METHOD, LIFE_YR_MO LIFE_YR_MO, YTD_DEPRN YTD_DEPRN, LTD_DEPRN LTD_DEPRN, COST COST, NBV NBV, PERIOD_NAME PERIOD_NAME, DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT, ASSET_COST_ACCT ASSET_COST_ACCT, COMPANY COMPANY, COST_CENTER COST_CENTER, ACCUM_DEPRN_ACCT ACCUM_DEPRN_ACCT, BOOK_TYPE_CODE BOOK_TYPE_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORIAL INVENTORIAL, ASSET_KEY ASSET_KEY, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, ADJUSTED_RATE ADJUSTED_RATE, CATEGORY_DESCRIPTION CATEGORY_DESCRIPTION, COMPANY_DESCRIPTION COMPANY_DESCRIPTION, COST_CENTER_DESCRIPTION COST_CENTER_DESCRIPTION, DEPRN_AMOUNT DEPRN_AMOUNT, EXPENSE_ACCT_DESCRIPTION EXPENSE_ACCT_DESCRIPTION, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, MAJOR_CATEGORY MAJOR_CATEGORY, MINOR_CATEGORY MINOR_CATEGORY, NBV_BEGINNING_FY NBV_BEGINNING_FY, ORGANIZATION_NAME ORGANIZATION_NAME, PERCENT PERCENT, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, MAJOR_CATEGORY_DESCRIPTION MAJOR_CATEGORY_DESCRIPTION, MINOR_CATEGORY_DESCRIPTION MINOR_CATEGORY_DESCRIPTION, SPECIFIED_CATEGORY_SEGMENT SPECIFIED_CATEGORY_SEGMENT, SPECIFIED_CATEGORY_SEG_DESC SPECIFIED_CATEGORY_SEG_DESC, RESERVE_ACCT_DESC RESERVE_ACCT_DESC, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER, SALVAGE_VALUE SALVAGE_VALUE from "FA"."FA_DEPRN_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, ASSET_NUMBER ASSET_NUMBER
, DESCRIPTION DESCRIPTION
, SERIAL_NUMBER SERIAL_NUMBER
, TAG_NUMBER TAG_NUMBER
, CATEGORY CATEGORY
, UNITS UNITS
, EMPLOYEE_NAME EMPLOYEE_NAME
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, LOCATION LOCATION
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, DEPRN_METHOD DEPRN_METHOD
, LIFE_YR_MO LIFE_YR_MO
, YTD_DEPRN YTD_DEPRN
, LTD_DEPRN LTD_DEPRN
, COST COST
, NBV NBV
, PERIOD_NAME PERIOD_NAME
, DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT
, ASSET_COST_ACCT ASSET_COST_ACCT
, COMPANY COMPANY
, COST_CENTER COST_CENTER
, ACCUM_DEPRN_ACCT ACCUM_DEPRN_ACCT
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORIAL INVENTORIAL
, ASSET_KEY ASSET_KEY
, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION
, ADJUSTED_RATE ADJUSTED_RATE
, CATEGORY_DESCRIPTION CATEGORY_DESCRIPTION
, COMPANY_DESCRIPTION COMPANY_DESCRIPTION
, COST_CENTER_DESCRIPTION COST_CENTER_DESCRIPTION
, DEPRN_AMOUNT DEPRN_AMOUNT
, EXPENSE_ACCT_DESCRIPTION EXPENSE_ACCT_DESCRIPTION
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, MAJOR_CATEGORY MAJOR_CATEGORY
, MINOR_CATEGORY MINOR_CATEGORY
, NBV_BEGINNING_FY NBV_BEGINNING_FY
, ORGANIZATION_NAME ORGANIZATION_NAME
, PERCENT PERCENT
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, MAJOR_CATEGORY_DESCRIPTION MAJOR_CATEGORY_DESCRIPTION
, MINOR_CATEGORY_DESCRIPTION MINOR_CATEGORY_DESCRIPTION
, SPECIFIED_CATEGORY_SEGMENT SPECIFIED_CATEGORY_SEGMENT
, SPECIFIED_CATEGORY_SEG_DESC SPECIFIED_CATEGORY_SEG_DESC
, RESERVE_ACCT_DESC RESERVE_ACCT_DESC
, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER
, SALVAGE_VALUE SALVAGE_VALUE
FROM "FA"."FA_DEPRN_REP_ITF"