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


VIEW: APPS.FA_BOOK_CONTROLS_MRC_V

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

[View Source]

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)
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_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)
REVAL_POSTING_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)
ALLOW_CIP_ASSETS_FLAG VARCHAR2 (3)
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
,      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_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
,      REVAL_POSTING_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
,      ALLOW_CIP_ASSETS_FLAG
,      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 APPS.FA_BOOK_CONTROLS_MRC_V;

Dependencies

[top of page]

APPS.FA_BOOK_CONTROLS_MRC_V references the following:

SchemaAPPS
SynonymFA_BOOK_CONTROLS
SynonymFA_MC_BOOK_CONTROLS
APPS.FA_BOOK_CONTROLS_MRC_V is referenced by following:

SchemaAPPS
Package BodyFARX_AL - show dependent code
ViewFA_AEL_SL_MRC_V
Package BodyFA_AMORT_PVT - show dependent code
Package BodyFA_BEGIN_MASS_TRX_PKG - show dependent code
Package BodyFA_BOOK_CONTROLS_PKG - show dependent code
Package BodyFA_CACHE_PKG - show dependent code
Package BodyFA_CALC_DEPRN_BASIS1_PKG - show dependent code
Package BodyFA_CALC_DEPRN_BASIS2_PKG - show dependent code
Package BodyFA_DEFERRED_DEPRN_PKG - show dependent code
Package BodyFA_FAS400_XMLP_PKG - show dependent code
Package BodyFA_FAS401_XMLP_PKG - show dependent code
Package BodyFA_FAS402_XMLP_PKG - show dependent code
Package BodyFA_FAS403_XMLP_PKG - show dependent code
Package BodyFA_FAS480_XMLP_PKG - show dependent code
Package BodyFA_FAS840_XMLP_PKG - show dependent code
Package BodyFA_FASCC_XMLP_PKG - show dependent code
Package BodyFA_FASCOSTD_XMLP_PKG - show dependent code
Package BodyFA_FASCOSTS_XMLP_PKG - show dependent code
Package BodyFA_FASRSVED_XMLP_PKG - show dependent code
Package BodyFA_FASRSVES_XMLP_PKG - show dependent code
Package BodyFA_GAINLOSS_MIS_PKG - show dependent code
Package BodyFA_MASS_DEPRN_BASIS_PKG - show dependent code
Package BodyFA_POLISH_PVT - show dependent code
Package BodyFA_RES_LDG_PKG - show dependent code
Package BodyFA_RSVLDG_REP_INS_PKG - show dependent code
Package BodyFA_TERMINAL_GAIN_LOSS_PVT - show dependent code
Package BodyJL_JLARFEFR_XMLP_PKG - show dependent code
Package BodyJL_JLMXFGLR_XMLP_PKG - show dependent code
Package BodyJL_JLMXFIMP_XMLP_PKG - show dependent code
Package BodyJL_JLMXFISR_XMLP_PKG - show dependent code
Package BodyJL_JLZZFIJR_XMLP_PKG - show dependent code
Package BodyJL_ZZ_FA_FUNCTIONS_PKG - show dependent code