VIEW: FA.FA_ASSET_LISTING_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, 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, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, COMPANY_DESCRIPTION COMPANY_DESCRIPTION, EXPENSE_ACCT_DESCRIPTION EXPENSE_ACCT_DESCRIPTION, COST_CENTER_DESCRIPTION COST_CENTER_DESCRIPTION, CATEGORY_DESCRIPTION CATEGORY_DESCRIPTION, ADJUSTED_RATE ADJUSTED_RATE, PERCENT PERCENT, ORGANIZATION_NAME ORGANIZATION_NAME, MAJOR_CATEGORY MAJOR_CATEGORY, MINOR_CATEGORY MINOR_CATEGORY, DEPRN_AMOUNT DEPRN_AMOUNT, BOOK_DEPRN_FLAG BOOK_DEPRN_FLAG, CATEGORY_DEPRN_FLAG CATEGORY_DEPRN_FLAG from "FA"."FA_ASSET_LISTING_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
, 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
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, COMPANY_DESCRIPTION COMPANY_DESCRIPTION
, EXPENSE_ACCT_DESCRIPTION EXPENSE_ACCT_DESCRIPTION
, COST_CENTER_DESCRIPTION COST_CENTER_DESCRIPTION
, CATEGORY_DESCRIPTION CATEGORY_DESCRIPTION
, ADJUSTED_RATE ADJUSTED_RATE
, PERCENT PERCENT
, ORGANIZATION_NAME ORGANIZATION_NAME
, MAJOR_CATEGORY MAJOR_CATEGORY
, MINOR_CATEGORY MINOR_CATEGORY
, DEPRN_AMOUNT DEPRN_AMOUNT
, BOOK_DEPRN_FLAG BOOK_DEPRN_FLAG
, CATEGORY_DEPRN_FLAG CATEGORY_DEPRN_FLAG
FROM "FA"."FA_ASSET_LISTING_REP_ITF"