VIEW: FA.FA_GROUP_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, 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, ORGANIZATION_NAME ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, DEPRN_CALENDAR DEPRN_CALENDAR, FISCAL_YEAR FISCAL_YEAR, GRP_ASSET_NUMBER GRP_ASSET_NUMBER, GRP_DESCRIPTION GRP_DESCRIPTION, GRP_ASSET_TYPE GRP_ASSET_TYPE, GRP_MAJOR_CATEGORY GRP_MAJOR_CATEGORY, GRP_MINOR_CATEGORY GRP_MINOR_CATEGORY, GRP_OTHER_CATEGORY GRP_OTHER_CATEGORY, GRP_DATE_PLACED_IN_SERVICE GRP_DATE_PLACED_IN_SERVICE, GRP_DEPRN_METHOD_CODE GRP_DEPRN_METHOD_CODE, GRP_RULE_NAME GRP_RULE_NAME, GRP_TRACKING_METHOD GRP_TRACKING_METHOD, GRP_COST GRP_COST, GRP_SALVAGE_VALUE GRP_SALVAGE_VALUE, GRP_ADJUSTED_RECOVERABLE_COST GRP_ADJUSTED_RECOVERABLE_COST, GRP_BEGINNING_NBV GRP_BEGINNING_NBV, GRP_FIRST_HALF_ADDITION GRP_FIRST_HALF_ADDITION, GRP_SECOND_HALF_ADDITION GRP_SECOND_HALF_ADDITION, GRP_ADDITION_AMOUNT GRP_ADDITION_AMOUNT, GRP_ADJUSTMENT_AMOUNT GRP_ADJUSTMENT_AMOUNT, GRP_NET_PROCEEDS GRP_NET_PROCEEDS, GRP_PROCEEDS_OF_SALE GRP_PROCEEDS_OF_SALE, GRP_COST_OF_REMOVAL GRP_COST_OF_REMOVAL, GRP_COST_RETIRED GRP_COST_RETIRED, GRP_RESERVE_RETIRED GRP_RESERVE_RETIRED, GRP_RECAPTURE_AMOUNT GRP_RECAPTURE_AMOUNT, GRP_TERMINAL_GAIN_LOSS_AMOUNT GRP_TERMINAL_GAIN_LOSS_AMOUNT, GRP_NBV_BEFORE_DEPRN GRP_NBV_BEFORE_DEPRN, GRP_DEPRN_BASIS_ADJUSTMENT GRP_DEPRN_BASIS_ADJUSTMENT, GRP_REDUCED_NBV GRP_REDUCED_NBV, GRP_ADJUSTED_RATE GRP_ADJUSTED_RATE, GRP_LIFE_YEAR_MONTH GRP_LIFE_YEAR_MONTH, GRP_REGULAR_DEPRN_AMOUNT GRP_REGULAR_DEPRN_AMOUNT, GRP_REDUCED_DEPRN_AMOUNT GRP_REDUCED_DEPRN_AMOUNT, GRP_ANNUAL_DEPRN_AMOUNT GRP_ANNUAL_DEPRN_AMOUNT, GRP_DEPRN_RESERVE GRP_DEPRN_RESERVE, GRP_ENDING_NBV GRP_ENDING_NBV, MEM_ASSET_NUMBER MEM_ASSET_NUMBER, MEM_DESCRIPTION MEM_DESCRIPTION, MEM_ASSET_TYPE MEM_ASSET_TYPE, MEM_MAJOR_CATEGORY MEM_MAJOR_CATEGORY, MEM_MINOR_CATEGORY MEM_MINOR_CATEGORY, MEM_OTHER_CATEGORY MEM_OTHER_CATEGORY, MEM_DATE_PLACED_IN_SERVICE MEM_DATE_PLACED_IN_SERVICE, MEM_DEPRN_METHOD_CODE MEM_DEPRN_METHOD_CODE, MEM_RULE_NAME MEM_RULE_NAME, MEM_COST MEM_COST, MEM_SALVAGE_VALUE MEM_SALVAGE_VALUE, MEM_ADJUSTED_RECOVERABLE_COST MEM_ADJUSTED_RECOVERABLE_COST, MEM_BEGINNING_NBV MEM_BEGINNING_NBV, MEM_FIRST_HALF_ADDITION MEM_FIRST_HALF_ADDITION, MEM_SECOND_HALF_ADDITION MEM_SECOND_HALF_ADDITION, MEM_ADDITION_AMOUNT MEM_ADDITION_AMOUNT, MEM_ADJUSTMENT_AMOUNT MEM_ADJUSTMENT_AMOUNT, MEM_NET_PROCEEDS MEM_NET_PROCEEDS, MEM_PROCEEDS_OF_SALE MEM_PROCEEDS_OF_SALE, MEM_COST_OF_REMOVAL MEM_COST_OF_REMOVAL, MEM_COST_RETIRED MEM_COST_RETIRED, MEM_RESERVE_RETIRED MEM_RESERVE_RETIRED, MEM_NBV_BEFORE_DEPRN MEM_NBV_BEFORE_DEPRN, MEM_DEPRN_BASIS_ADJUSTMENT MEM_DEPRN_BASIS_ADJUSTMENT, MEM_REDUCED_NBV MEM_REDUCED_NBV, MEM_ADJUSTED_RATE MEM_ADJUSTED_RATE, MEM_LIFE_YEAR_MONTH MEM_LIFE_YEAR_MONTH, MEM_ANNUAL_DEPRN_AMOUNT MEM_ANNUAL_DEPRN_AMOUNT, MEM_DEPRN_RESERVE MEM_DEPRN_RESERVE, MEM_ENDING_NBV MEM_ENDING_NBV, MEM_STATUS MEM_STATUS from "FA"."FA_GROUP_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, 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
, ORGANIZATION_NAME ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, DEPRN_CALENDAR DEPRN_CALENDAR
, FISCAL_YEAR FISCAL_YEAR
, GRP_ASSET_NUMBER GRP_ASSET_NUMBER
, GRP_DESCRIPTION GRP_DESCRIPTION
, GRP_ASSET_TYPE GRP_ASSET_TYPE
, GRP_MAJOR_CATEGORY GRP_MAJOR_CATEGORY
, GRP_MINOR_CATEGORY GRP_MINOR_CATEGORY
, GRP_OTHER_CATEGORY GRP_OTHER_CATEGORY
, GRP_DATE_PLACED_IN_SERVICE GRP_DATE_PLACED_IN_SERVICE
, GRP_DEPRN_METHOD_CODE GRP_DEPRN_METHOD_CODE
, GRP_RULE_NAME GRP_RULE_NAME
, GRP_TRACKING_METHOD GRP_TRACKING_METHOD
, GRP_COST GRP_COST
, GRP_SALVAGE_VALUE GRP_SALVAGE_VALUE
, GRP_ADJUSTED_RECOVERABLE_COST GRP_ADJUSTED_RECOVERABLE_COST
, GRP_BEGINNING_NBV GRP_BEGINNING_NBV
, GRP_FIRST_HALF_ADDITION GRP_FIRST_HALF_ADDITION
, GRP_SECOND_HALF_ADDITION GRP_SECOND_HALF_ADDITION
, GRP_ADDITION_AMOUNT GRP_ADDITION_AMOUNT
, GRP_ADJUSTMENT_AMOUNT GRP_ADJUSTMENT_AMOUNT
, GRP_NET_PROCEEDS GRP_NET_PROCEEDS
, GRP_PROCEEDS_OF_SALE GRP_PROCEEDS_OF_SALE
, GRP_COST_OF_REMOVAL GRP_COST_OF_REMOVAL
, GRP_COST_RETIRED GRP_COST_RETIRED
, GRP_RESERVE_RETIRED GRP_RESERVE_RETIRED
, GRP_RECAPTURE_AMOUNT GRP_RECAPTURE_AMOUNT
, GRP_TERMINAL_GAIN_LOSS_AMOUNT GRP_TERMINAL_GAIN_LOSS_AMOUNT
, GRP_NBV_BEFORE_DEPRN GRP_NBV_BEFORE_DEPRN
, GRP_DEPRN_BASIS_ADJUSTMENT GRP_DEPRN_BASIS_ADJUSTMENT
, GRP_REDUCED_NBV GRP_REDUCED_NBV
, GRP_ADJUSTED_RATE GRP_ADJUSTED_RATE
, GRP_LIFE_YEAR_MONTH GRP_LIFE_YEAR_MONTH
, GRP_REGULAR_DEPRN_AMOUNT GRP_REGULAR_DEPRN_AMOUNT
, GRP_REDUCED_DEPRN_AMOUNT GRP_REDUCED_DEPRN_AMOUNT
, GRP_ANNUAL_DEPRN_AMOUNT GRP_ANNUAL_DEPRN_AMOUNT
, GRP_DEPRN_RESERVE GRP_DEPRN_RESERVE
, GRP_ENDING_NBV GRP_ENDING_NBV
, MEM_ASSET_NUMBER MEM_ASSET_NUMBER
, MEM_DESCRIPTION MEM_DESCRIPTION
, MEM_ASSET_TYPE MEM_ASSET_TYPE
, MEM_MAJOR_CATEGORY MEM_MAJOR_CATEGORY
, MEM_MINOR_CATEGORY MEM_MINOR_CATEGORY
, MEM_OTHER_CATEGORY MEM_OTHER_CATEGORY
, MEM_DATE_PLACED_IN_SERVICE MEM_DATE_PLACED_IN_SERVICE
, MEM_DEPRN_METHOD_CODE MEM_DEPRN_METHOD_CODE
, MEM_RULE_NAME MEM_RULE_NAME
, MEM_COST MEM_COST
, MEM_SALVAGE_VALUE MEM_SALVAGE_VALUE
, MEM_ADJUSTED_RECOVERABLE_COST MEM_ADJUSTED_RECOVERABLE_COST
, MEM_BEGINNING_NBV MEM_BEGINNING_NBV
, MEM_FIRST_HALF_ADDITION MEM_FIRST_HALF_ADDITION
, MEM_SECOND_HALF_ADDITION MEM_SECOND_HALF_ADDITION
, MEM_ADDITION_AMOUNT MEM_ADDITION_AMOUNT
, MEM_ADJUSTMENT_AMOUNT MEM_ADJUSTMENT_AMOUNT
, MEM_NET_PROCEEDS MEM_NET_PROCEEDS
, MEM_PROCEEDS_OF_SALE MEM_PROCEEDS_OF_SALE
, MEM_COST_OF_REMOVAL MEM_COST_OF_REMOVAL
, MEM_COST_RETIRED MEM_COST_RETIRED
, MEM_RESERVE_RETIRED MEM_RESERVE_RETIRED
, MEM_NBV_BEFORE_DEPRN MEM_NBV_BEFORE_DEPRN
, MEM_DEPRN_BASIS_ADJUSTMENT MEM_DEPRN_BASIS_ADJUSTMENT
, MEM_REDUCED_NBV MEM_REDUCED_NBV
, MEM_ADJUSTED_RATE MEM_ADJUSTED_RATE
, MEM_LIFE_YEAR_MONTH MEM_LIFE_YEAR_MONTH
, MEM_ANNUAL_DEPRN_AMOUNT MEM_ANNUAL_DEPRN_AMOUNT
, MEM_DEPRN_RESERVE MEM_DEPRN_RESERVE
, MEM_ENDING_NBV MEM_ENDING_NBV
, MEM_STATUS MEM_STATUS
FROM "FA"."FA_GROUP_REP_ITF"