DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.FAFV_BOOKS

Object Details
Object Name: FAFV_BOOKS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FAFV_BOOKS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BOOK_TYPE_CODE VARCHAR2 (15) Yes
BOOK_TYPE_NAME VARCHAR2 (30) Yes
INITIAL_DATE DATE
Yes
LAST_DEPRN_RUN_DATE DATE
Yes
AMORTIZE_FLAG VARCHAR2 (3) Yes
DEPRN_CALENDAR VARCHAR2 (15) Yes
BOOK_CLASS VARCHAR2 (15) Yes
GL_POSTING_ALLOWED_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)
JE_REVAL_CATEGORY VARCHAR2 (30)
MASS_COPY_SOURCE_BOOK VARCHAR2 (15)
NBV_RETIRED_GAIN_ACCT VARCHAR2 (25) Yes
NBV_RETIRED_LOSS_ACCT 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)
REVAL_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
LEDGER_NAME VARCHAR2 (30) Yes
LAST_PERIOD_COUNTER NUMBER (15) Yes
LAST_PERIOD_NAME VARCHAR2 (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15)
CREATION_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BOOK_TYPE_CODE
,      BOOK_TYPE_NAME
,      INITIAL_DATE
,      LAST_DEPRN_RUN_DATE
,      AMORTIZE_FLAG
,      DEPRN_CALENDAR
,      BOOK_CLASS
,      GL_POSTING_ALLOWED_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
,      JE_REVAL_CATEGORY
,      MASS_COPY_SOURCE_BOOK
,      NBV_RETIRED_GAIN_ACCT
,      NBV_RETIRED_LOSS_ACCT
,      PROCEEDS_OF_SALE_CLEARING_ACCT
,      PROCEEDS_OF_SALE_GAIN_ACCT
,      PROCEEDS_OF_SALE_LOSS_ACCT
,      REVALUE_ON_RETIREMENT_FLAG
,      REVAL_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
,      LEDGER_NAME
,      LAST_PERIOD_COUNTER
,      LAST_PERIOD_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.FAFV_BOOKS;

Dependencies

[top of page]

APPS.FAFV_BOOKS references the following:

SchemaAPPS
SynonymFA_BOOK_CONTROLS
SynonymFA_DEPRN_PERIODS
ViewGL_SETS_OF_BOOKS

APPS.FAFV_BOOKS is not referenced by any database object