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

TABLE: FA.FA_BOOK_CONTROLS

Object Details
Object Name: FA_BOOK_CONTROLS
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_BOOK_CONTROLS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_BOOK_CONTROLS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOOK_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
BOOK_TYPE_CODE VARCHAR2 (15) Yes
BOOK_TYPE_NAME VARCHAR2 (30) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
INITIAL_DATE DATE
Yes
LAST_DEPRN_RUN_DATE DATE
Yes
AMORTIZE_FLAG VARCHAR2 (3) Yes
FULLY_RESERVED_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
ACCOUNTING_FLEX_STRUCTURE NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) 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
DEPRN_REQUEST_ID NUMBER (15)
ALLOW_COST_CEILING VARCHAR2 (3) Yes
ALLOW_DEPRN_EXP_CEILING VARCHAR2 (3) Yes
CALCULATE_NBV VARCHAR2 (3) Yes
RUN_YEAR_END_PROGRAM VARCHAR2 (3) Yes
JE_DEFERRED_DEPRN_CATEGORY VARCHAR2 (30)
ALLOW_CIP_ASSETS_FLAG VARCHAR2 (3)
ITC_ALLOWED_FLAG VARCHAR2 (3) Yes
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
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
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY_CODE VARCHAR2 (30)
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

DEFAULT_MAX_FULLY_RSVD_REVALS NUMBER (15)
DEFAULT_REVAL_FULLY_RSVD_FLAG VARCHAR2 (3)
DEFERRED_DEPRN_EXPENSE_ACCT VARCHAR2 (25) Yes
DEFERRED_DEPRN_RESERVE_ACCT VARCHAR2 (25) Yes
DEPRN_ALLOCATION_CODE VARCHAR2 (1) Yes
DEPRN_STATUS VARCHAR2 (1)
FISCAL_YEAR_NAME VARCHAR2 (30)
INITIAL_PERIOD_COUNTER NUMBER (15) Yes
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)
LAST_MASS_COPY_PERIOD_COUNTER NUMBER (15)
LAST_PERIOD_COUNTER NUMBER (15) Yes
LAST_PURGE_PERIOD_COUNTER NUMBER (15)
MASS_COPY_SOURCE_BOOK VARCHAR2 (15)
MASS_REQUEST_ID NUMBER (15)
NBV_AMOUNT_THRESHOLD NUMBER

NBV_FRACTION_THRESHOLD NUMBER

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_POSTING_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
IMMEDIATE_COPY_FLAG VARCHAR2 (3)
JE_DEPRN_ADJUSTMENT_CATEGORY VARCHAR2 (30)
DEPR_FIRST_YEAR_RET_FLAG VARCHAR2 (3) Yes
FLEXBUILDER_DEFAULTS_CCID NUMBER (15) Yes
RETIRE_REVAL_RESERVE_FLAG VARCHAR2 (3)
USE_CURRENT_NBV_FOR_DEPRN VARCHAR2 (3) Yes
COPY_ADDITIONS_FLAG VARCHAR2 (3) Yes
USE_PERCENT_SALVAGE_VALUE_FLAG VARCHAR2 (3)
MC_SOURCE_FLAG VARCHAR2 (1)
REVAL_YTD_DEPRN_FLAG VARCHAR2 (3)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ORG_ID NUMBER (15)
ALLOW_GROUP_DEPRN_FLAG VARCHAR2 (1)
ALLOW_CIP_DEP_GROUP_FLAG VARCHAR2 (1)
ALLOW_INTERCO_GROUP_FLAG VARCHAR2 (1)
COPY_GROUP_ASSIGNMENT_FLAG VARCHAR2 (1)
COPY_GROUP_ADDITION_FLAG VARCHAR2 (1)
ALLOW_CIP_MEMBER_FLAG VARCHAR2 (1)
ALLOW_MEMBER_TRACKING_FLAG VARCHAR2 (1)
INTERCOMPANY_POSTING_FLAG VARCHAR2 (1)
ALLOW_BACKDATED_TRANSFERS_FLAG VARCHAR2 (1)
ALLOW_COST_SIGN_CHANGE_FLAG VARCHAR2 (1)
CREATE_ACCOUNTING_REQUEST_ID NUMBER (15)
ALLOW_IMPAIRMENT_FLAG VARCHAR2 (1)
Query Text

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


SELECT BOOK_TYPE_CODE
,      BOOK_TYPE_NAME
,      SET_OF_BOOKS_ID
,      INITIAL_DATE
,      LAST_DEPRN_RUN_DATE
,      AMORTIZE_FLAG
,      FULLY_RESERVED_FLAG
,      DEPRN_CALENDAR
,      BOOK_CLASS
,      GL_POSTING_ALLOWED_FLAG
,      CURRENT_FISCAL_YEAR
,      ALLOW_MASS_CHANGES
,      ALLOW_DEPRN_ADJUSTMENTS
,      ACCOUNTING_FLEX_STRUCTURE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      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
,      DEPRN_REQUEST_ID
,      ALLOW_COST_CEILING
,      ALLOW_DEPRN_EXP_CEILING
,      CALCULATE_NBV
,      RUN_YEAR_END_PROGRAM
,      JE_DEFERRED_DEPRN_CATEGORY
,      ALLOW_CIP_ASSETS_FLAG
,      ITC_ALLOWED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      ALLOW_MASS_COPY
,      ALLOW_PURGE_FLAG
,      ALLOW_REVAL_FLAG
,      AMORTIZE_REVAL_RESERVE_FLAG
,      AP_INTERCOMPANY_ACCT
,      AR_INTERCOMPANY_ACCT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      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
,      DEFAULT_MAX_FULLY_RSVD_REVALS
,      DEFAULT_REVAL_FULLY_RSVD_FLAG
,      DEFERRED_DEPRN_EXPENSE_ACCT
,      DEFERRED_DEPRN_RESERVE_ACCT
,      DEPRN_ALLOCATION_CODE
,      DEPRN_STATUS
,      FISCAL_YEAR_NAME
,      INITIAL_PERIOD_COUNTER
,      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
,      LAST_MASS_COPY_PERIOD_COUNTER
,      LAST_PERIOD_COUNTER
,      LAST_PURGE_PERIOD_COUNTER
,      MASS_COPY_SOURCE_BOOK
,      MASS_REQUEST_ID
,      NBV_AMOUNT_THRESHOLD
,      NBV_FRACTION_THRESHOLD
,      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_POSTING_FLAG
,      REVAL_RSV_RETIRED_GAIN_ACCT
,      REVAL_RSV_RETIRED_LOSS_ACCT
,      DEPRN_ADJUSTMENT_ACCT
,      IMMEDIATE_COPY_FLAG
,      JE_DEPRN_ADJUSTMENT_CATEGORY
,      DEPR_FIRST_YEAR_RET_FLAG
,      FLEXBUILDER_DEFAULTS_CCID
,      RETIRE_REVAL_RESERVE_FLAG
,      USE_CURRENT_NBV_FOR_DEPRN
,      COPY_ADDITIONS_FLAG
,      USE_PERCENT_SALVAGE_VALUE_FLAG
,      MC_SOURCE_FLAG
,      REVAL_YTD_DEPRN_FLAG
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      ORG_ID
,      ALLOW_GROUP_DEPRN_FLAG
,      ALLOW_CIP_DEP_GROUP_FLAG
,      ALLOW_INTERCO_GROUP_FLAG
,      COPY_GROUP_ASSIGNMENT_FLAG
,      COPY_GROUP_ADDITION_FLAG
,      ALLOW_CIP_MEMBER_FLAG
,      ALLOW_MEMBER_TRACKING_FLAG
,      INTERCOMPANY_POSTING_FLAG
,      ALLOW_BACKDATED_TRANSFERS_FLAG
,      ALLOW_COST_SIGN_CHANGE_FLAG
,      CREATE_ACCOUNTING_REQUEST_ID
,      ALLOW_IMPAIRMENT_FLAG
FROM FA.FA_BOOK_CONTROLS;

Dependencies

[top of page]

FA.FA_BOOK_CONTROLS does not reference any database object

FA.FA_BOOK_CONTROLS is referenced by following:

SchemaAPPS
SynonymFA_BOOK_CONTROLS
SynonymFA_BOOK_CONTROLS_BAS
SynonymFA_BOOK_CONTROLS_SEC
TriggerIGI_MHC_FA_BOOK_CONTROLS_T1