eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	OFA.FA_BOOK_CONTROLS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_BOOK_CONTROLS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory
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:

APPS: FA_BOOK_CONTROLS; FA_BOOK_CONTROLS_BAS; FA_BOOK_CONTROLS_SEC; IGI_MHC_FA_BOOK_CONTROLS_T1