[Home] [Help]
[Dependency Information]
| Object Name: | FABV_BOOKS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | OFA.FABV_BOOKS
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BOOK_NAME | VARCHAR2 | (15) | Yes | |
| BOOK_TYPE_NAME | VARCHAR2 | (30) | Yes | |
| INITIAL_DATE | DATE | Yes | ||
| LAST_DEPRN_RUN_DATE | DATE | Yes | ||
| ALLOW_AMORTIZE_FLAG | VARCHAR2 | (3) | Yes | |
| DEPRN_CALENDAR | VARCHAR2 | (15) | Yes | |
| BOOK_CLASS | VARCHAR2 | (15) | Yes | |
| ALLOWED_GL_POSTING_FLAG | VARCHAR2 | (3) | Yes | |
| CURRENT_FISCAL_YEAR | NUMBER | (4) | Yes | |
| ALLOW_MASS_CHANGES | VARCHAR2 | (3) | Yes | |
| ALLOW_DEPRN_ADJUSTMENTS | VARCHAR2 | (3) | Yes | |
| PRORATE_CALENDAR | VARCHAR2 | (15) | Yes | |
| DATE_INEFFECTIVE | DATE | |||
| JE_RETIREMENT_CATEGORY | VARCHAR2 | (30) | ||
| JE_DEPRECIATION_CATEGORY | VARCHAR2 | (30) | ||
| JE_RECLASS_CATEGORY | VARCHAR2 | (30) | ||
| GL_JE_SOURCE | VARCHAR2 | (30) | ||
| JE_ADDITION_CATEGORY | VARCHAR2 | (30) | ||
| JE_ADJUSTMENT_CATEGORY | VARCHAR2 | (30) | ||
| DISTRIBUTION_SOURCE_BOOK | VARCHAR2 | (15) | ||
| JE_TRANSFER_CATEGORY | VARCHAR2 | (30) | ||
| COPY_RETIREMENTS_FLAG | VARCHAR2 | (3) | Yes | |
| COPY_ADJUSTMENTS_FLAG | VARCHAR2 | (3) | Yes | |
| ALLOW_COST_CEILING | VARCHAR2 | (3) | Yes | |
| ALLOW_DEPRN_EXP_CEILING | VARCHAR2 | (3) | Yes | |
| JE_DEFERRED_DEPRN_CATEGORY | VARCHAR2 | (30) | ||
| ITC_ALLOWED_FLAG | VARCHAR2 | (3) | Yes | |
| ALLOW_MASS_COPY | VARCHAR2 | (3) | Yes | |
| ALLOW_PURGE_FLAG | VARCHAR2 | (3) | ||
| ALLOW_REVAL_FLAG | VARCHAR2 | (3) | Yes | |
| AMORTIZE_REVAL_RESERVE_FLAG | VARCHAR2 | (3) | ||
| AP_INTERCOMPANY_ACCT | VARCHAR2 | (25) | Yes | |
| AR_INTERCOMPANY_ACCT | VARCHAR2 | (25) | Yes | |
| CAPITAL_GAIN_THRESHOLD | NUMBER | |||
| COPY_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | Yes | |
| COST_OF_REMOVAL_CLEARING_ACCT | VARCHAR2 | (25) | Yes | |
| COST_OF_REMOVAL_GAIN_ACCT | VARCHAR2 | (25) | Yes | |
| COST_OF_REMOVAL_LOSS_ACCT | VARCHAR2 | (25) | Yes | |
| DEFAULT_LIFE_EXTENSION_CEILING | NUMBER | |||
| DEFAULT_LIFE_EXTENSION_FACTOR | NUMBER | |||
| DEFERRED_DEPRN_EXPENSE_ACCT | VARCHAR2 | (25) | Yes | |
| DEFERRED_DEPRN_RESERVE_ACCT | VARCHAR2 | (25) | Yes | |
| FISCAL_YEAR_NAME | VARCHAR2 | (30) | ||
| JE_CIP_ADJUSTMENT_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_ADDITION_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_RECLASS_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_RETIREMENT_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_REVAL_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_TRANSFER_CATEGORY | VARCHAR2 | (30) | ||
| REVALUATION_JOURNAL_CATEGORY | VARCHAR2 | (30) | ||
| MASS_COPY_SOURCE_BOOK | VARCHAR2 | (15) | ||
| NBV_RETIRED_GAIN_ACCT_CODE | VARCHAR2 | (25) | Yes | |
| NBV_RETIRED_LOSS_ACCT_CODE | VARCHAR2 | (25) | Yes | |
| PROCEEDS_OF_SALE_CLEARING_ACCT | VARCHAR2 | (25) | Yes | |
| PROCEEDS_OF_SALE_GAIN_ACCT | VARCHAR2 | (25) | Yes | |
| PROCEEDS_OF_SALE_LOSS_ACCT | VARCHAR2 | (25) | Yes | |
| REVALUE_ON_RETIREMENT_FLAG | VARCHAR2 | (3) | ||
| REVALUE_DEPRN_RESERVE_FLAG | VARCHAR2 | (3) | ||
| REVAL_RSV_RETIRED_GAIN_ACCT | VARCHAR2 | (25) | Yes | |
| REVAL_RSV_RETIRED_LOSS_ACCT | VARCHAR2 | (25) | Yes | |
| DEPRN_ADJUSTMENT_ACCT | VARCHAR2 | (25) | Yes | |
| JE_DEPRN_ADJUSTMENT_CATEGORY | VARCHAR2 | (30) | ||
| DEPR_FIRST_YEAR_RET_FLAG | VARCHAR2 | (3) | Yes | |
| RETIRE_REVAL_RESERVE_FLAG | VARCHAR2 | (3) | ||
| COPY_ADDITIONS_FLAG | VARCHAR2 | (3) | Yes | |
| MC_SOURCE_FLAG | VARCHAR2 | (1) | ||
| LEDGER_ID | NUMBER | (15) | Yes | |
| INITIAL_PERIOD_COUNTER | NUMBER | (15) | Yes | |
| LAST_PERIOD_COUNTER | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_NAME
, BOOK_TYPE_NAME
, INITIAL_DATE
, LAST_DEPRN_RUN_DATE
, ALLOW_AMORTIZE_FLAG
, DEPRN_CALENDAR
, BOOK_CLASS
, ALLOWED_GL_POSTING_FLAG
, CURRENT_FISCAL_YEAR
, ALLOW_MASS_CHANGES
, ALLOW_DEPRN_ADJUSTMENTS
, PRORATE_CALENDAR
, DATE_INEFFECTIVE
, JE_RETIREMENT_CATEGORY
, JE_DEPRECIATION_CATEGORY
, JE_RECLASS_CATEGORY
, GL_JE_SOURCE
, JE_ADDITION_CATEGORY
, JE_ADJUSTMENT_CATEGORY
, DISTRIBUTION_SOURCE_BOOK
, JE_TRANSFER_CATEGORY
, COPY_RETIREMENTS_FLAG
, COPY_ADJUSTMENTS_FLAG
, ALLOW_COST_CEILING
, ALLOW_DEPRN_EXP_CEILING
, JE_DEFERRED_DEPRN_CATEGORY
, ITC_ALLOWED_FLAG
, ALLOW_MASS_COPY
, ALLOW_PURGE_FLAG
, ALLOW_REVAL_FLAG
, AMORTIZE_REVAL_RESERVE_FLAG
, AP_INTERCOMPANY_ACCT
, AR_INTERCOMPANY_ACCT
, CAPITAL_GAIN_THRESHOLD
, COPY_SALVAGE_VALUE_FLAG
, COST_OF_REMOVAL_CLEARING_ACCT
, COST_OF_REMOVAL_GAIN_ACCT
, COST_OF_REMOVAL_LOSS_ACCT
, DEFAULT_LIFE_EXTENSION_CEILING
, DEFAULT_LIFE_EXTENSION_FACTOR
, DEFERRED_DEPRN_EXPENSE_ACCT
, DEFERRED_DEPRN_RESERVE_ACCT
, FISCAL_YEAR_NAME
, JE_CIP_ADJUSTMENT_CATEGORY
, JE_CIP_ADDITION_CATEGORY
, JE_CIP_RECLASS_CATEGORY
, JE_CIP_RETIREMENT_CATEGORY
, JE_CIP_REVAL_CATEGORY
, JE_CIP_TRANSFER_CATEGORY
, REVALUATION_JOURNAL_CATEGORY
, MASS_COPY_SOURCE_BOOK
, NBV_RETIRED_GAIN_ACCT_CODE
, NBV_RETIRED_LOSS_ACCT_CODE
, PROCEEDS_OF_SALE_CLEARING_ACCT
, PROCEEDS_OF_SALE_GAIN_ACCT
, PROCEEDS_OF_SALE_LOSS_ACCT
, REVALUE_ON_RETIREMENT_FLAG
, REVALUE_DEPRN_RESERVE_FLAG
, REVAL_RSV_RETIRED_GAIN_ACCT
, REVAL_RSV_RETIRED_LOSS_ACCT
, DEPRN_ADJUSTMENT_ACCT
, JE_DEPRN_ADJUSTMENT_CATEGORY
, DEPR_FIRST_YEAR_RET_FLAG
, RETIRE_REVAL_RESERVE_FLAG
, COPY_ADDITIONS_FLAG
, MC_SOURCE_FLAG
, LEDGER_ID
, INITIAL_PERIOD_COUNTER
, LAST_PERIOD_COUNTER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.FABV_BOOKS;
APPS
FA_BOOK_CONTROLS
APPS.FABV_BOOKS is not referenced by any database object
|
|
|
|