VIEW: FA.FA_GROUP_ASSET_DEFAULT#

Source

View Text - Preformatted

select GROUP_ASSET_ID GROUP_ASSET_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, SUPER_GROUP_ID SUPER_GROUP_ID, ASSET_COST_ACCT ASSET_COST_ACCT, ASSET_CLEARING_ACCT ASSET_CLEARING_ACCT, DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT, REVAL_AMORTIZATION_ACCT REVAL_AMORTIZATION_ACCT, REVAL_AMORTIZATION_ACCT_CCID REVAL_AMORTIZATION_ACCT_CCID, REVAL_RESERVE_ACCT REVAL_RESERVE_ACCT, PROCEEDS_OF_SALE_GAIN_ACCT PROCEEDS_OF_SALE_GAIN_ACCT, PROCEEDS_OF_SALE_LOSS_ACCT PROCEEDS_OF_SALE_LOSS_ACCT, PROCEEDS_OF_SALE_CLEARING_ACCT PROCEEDS_OF_SALE_CLEARING_ACCT, COST_OF_REMOVAL_GAIN_ACCT COST_OF_REMOVAL_GAIN_ACCT, COST_OF_REMOVAL_LOSS_ACCT COST_OF_REMOVAL_LOSS_ACCT, NBV_RETIRED_GAIN_ACCT NBV_RETIRED_GAIN_ACCT, NBV_RETIRED_LOSS_ACCT NBV_RETIRED_LOSS_ACCT, REVAL_RSV_RETIRED_GAIN_ACCT REVAL_RSV_RETIRED_GAIN_ACCT, REVAL_RSV_RETIRED_LOSS_ACCT REVAL_RSV_RETIRED_LOSS_ACCT, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, RESERVE_ACCOUNT_CCID RESERVE_ACCOUNT_CCID, REVAL_RESERVE_ACCT_CCID REVAL_RESERVE_ACCT_CCID, ASSET_COST_ACCT_CCID ASSET_COST_ACCT_CCID, ASSET_CLEARING_ACCT_CCID ASSET_CLEARING_ACCT_CCID, DEPRN_RESERVE_ACCT_CCID DEPRN_RESERVE_ACCT_CCID, DEPRN_EXPENSE_ACCT_CCID DEPRN_EXPENSE_ACCT_CCID, REVAL_AMORT_ACCOUNT_CCID REVAL_AMORT_ACCOUNT_CCID, COST_OF_REMOVAL_CLEARING_ACCT COST_OF_REMOVAL_CLEARING_ACCT, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20 from "FA"."FA_GROUP_ASSET_DEFAULT"

View Text - HTML Formatted

SELECT GROUP_ASSET_ID GROUP_ASSET_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, SUPER_GROUP_ID SUPER_GROUP_ID
, ASSET_COST_ACCT ASSET_COST_ACCT
, ASSET_CLEARING_ACCT ASSET_CLEARING_ACCT
, DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT
, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT
, REVAL_AMORTIZATION_ACCT REVAL_AMORTIZATION_ACCT
, REVAL_AMORTIZATION_ACCT_CCID REVAL_AMORTIZATION_ACCT_CCID
, REVAL_RESERVE_ACCT REVAL_RESERVE_ACCT
, PROCEEDS_OF_SALE_GAIN_ACCT PROCEEDS_OF_SALE_GAIN_ACCT
, PROCEEDS_OF_SALE_LOSS_ACCT PROCEEDS_OF_SALE_LOSS_ACCT
, PROCEEDS_OF_SALE_CLEARING_ACCT PROCEEDS_OF_SALE_CLEARING_ACCT
, COST_OF_REMOVAL_GAIN_ACCT COST_OF_REMOVAL_GAIN_ACCT
, COST_OF_REMOVAL_LOSS_ACCT COST_OF_REMOVAL_LOSS_ACCT
, NBV_RETIRED_GAIN_ACCT NBV_RETIRED_GAIN_ACCT
, NBV_RETIRED_LOSS_ACCT NBV_RETIRED_LOSS_ACCT
, REVAL_RSV_RETIRED_GAIN_ACCT REVAL_RSV_RETIRED_GAIN_ACCT
, REVAL_RSV_RETIRED_LOSS_ACCT REVAL_RSV_RETIRED_LOSS_ACCT
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, RESERVE_ACCOUNT_CCID RESERVE_ACCOUNT_CCID
, REVAL_RESERVE_ACCT_CCID REVAL_RESERVE_ACCT_CCID
, ASSET_COST_ACCT_CCID ASSET_COST_ACCT_CCID
, ASSET_CLEARING_ACCT_CCID ASSET_CLEARING_ACCT_CCID
, DEPRN_RESERVE_ACCT_CCID DEPRN_RESERVE_ACCT_CCID
, DEPRN_EXPENSE_ACCT_CCID DEPRN_EXPENSE_ACCT_CCID
, REVAL_AMORT_ACCOUNT_CCID REVAL_AMORT_ACCOUNT_CCID
, COST_OF_REMOVAL_CLEARING_ACCT COST_OF_REMOVAL_CLEARING_ACCT
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
FROM "FA"."FA_GROUP_ASSET_DEFAULT"