eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: FA.JE_DE_FA_SUMMARY#

Source

View Text - Preformatted


select ASSET_ID ASSET_ID, TYPE TYPE, DATE_RUN DATE_RUN, YEAR YEAR, MAJOR_CATEGORY MAJOR_CATEGORY, CAPITALIZED_ACCOUNT CAPITALIZED_ACCOUNT, CIP_ACCOUNT CIP_ACCOUNT, ASSET_COST ASSET_COST, ADDITIONS ADDITIONS, RETIREMENTS RETIREMENTS, TRANSFERS TRANSFERS, APPRECIATIONS APPRECIATIONS, DEPR_RESRV DEPR_RESRV, DEPR_CURRENT DEPR_CURRENT, NBV_BEGIN NBV_BEGIN, NBV_END NBV_END, BOOK_TYPE_CODE BOOK_TYPE_CODE, CONC_REQUEST_ID CONC_REQUEST_ID from "FA"."JE_DE_FA_SUMMARY"

View Text - HTML Formatted

SELECT ASSET_ID ASSET_ID
, TYPE TYPE
, DATE_RUN DATE_RUN
, YEAR YEAR
, MAJOR_CATEGORY MAJOR_CATEGORY
, CAPITALIZED_ACCOUNT CAPITALIZED_ACCOUNT
, CIP_ACCOUNT CIP_ACCOUNT
, ASSET_COST ASSET_COST
, ADDITIONS ADDITIONS
, RETIREMENTS RETIREMENTS
, TRANSFERS TRANSFERS
, APPRECIATIONS APPRECIATIONS
, DEPR_RESRV DEPR_RESRV
, DEPR_CURRENT DEPR_CURRENT
, NBV_BEGIN NBV_BEGIN
, NBV_END NBV_END
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, CONC_REQUEST_ID CONC_REQUEST_ID
FROM "FA"."JE_DE_FA_SUMMARY"