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

TABLE: FA.FA_SUPER_GROUP_RULES

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


Defines the depreciation rules to be followed when depreciating asset groups that are members of the super group.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_SUPER_GROUP_RULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDATE_INEFFECTIVE
FA_SUPER_GROUP_RULES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPER_GROUP_ID
ColumnBOOK_TYPE_CODE
ColumnSTART_PERIOD_COUNTER
ColumnDATE_EFFECTIVE
Columns
Name Datatype Length Mandatory Comments
SUPER_GROUP_ID NUMBER (15) Yes Super group identifier
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book identifier.
DATE_EFFECTIVE DATE
Yes Date when the rates etc. became effective.
DEPRN_METHOD_CODE VARCHAR2 (15) Yes Depreciation method to be used when depreciating group assets in the super group.
BASIC_RATE NUMBER
Yes Depreciation rate to be used when depreciating group assets in the super group.
ADJUSTED_RATE NUMBER
Yes Adjusted depreciation rate to be used when depreciating group assets in the super group.
PERCENT_SALVAGE_VALUE NUMBER
Yes Estimated net salvage of the super group expressed as a percentage of total investment.
DATE_INEFFECTIVE DATE

Date after which the rates etc. were no longer effective.
CREATION_DATE DATE
Yes Standard WHO column.
CREATED_BY NUMBER (15) Yes Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Yes Standard WHO column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
START_PERIOD_COUNTER NUMBER (15) Yes Identifies the period when the super group becomes effective.
END_PERIOD_COUNTER NUMBER (15)
Identifies the period when the super group becomes ineffective.
ADJUSTMENT_REQUIRED_FLAG VARCHAR2 (1)
Indicates if the super group rules change is being processed.
USED_FLAG VARCHAR2 (1)
Indicates whether the super group is in use
Query Text

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


SELECT SUPER_GROUP_ID
,      BOOK_TYPE_CODE
,      DATE_EFFECTIVE
,      DEPRN_METHOD_CODE
,      BASIC_RATE
,      ADJUSTED_RATE
,      PERCENT_SALVAGE_VALUE
,      DATE_INEFFECTIVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      START_PERIOD_COUNTER
,      END_PERIOD_COUNTER
,      ADJUSTMENT_REQUIRED_FLAG
,      USED_FLAG
FROM FA.FA_SUPER_GROUP_RULES;

Dependencies

[top of page]

FA.FA_SUPER_GROUP_RULES does not reference any database object

FA.FA_SUPER_GROUP_RULES is referenced by following:

SchemaFA
ViewFA_SUPER_GROUP_RULES#