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

TABLE: FA.FA_HIERARCHY_RULE_DETAILS

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


Specific rules for a rule set, detailing how attributes are derived and where they are derived from.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_HIERARCHY_RULE_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHIERARCHY_RULE_SET_ID
ColumnATTRIBUTE_NAME
ColumnBOOK_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_RULE_SET_ID NUMBER
Yes Rule set ID.
ATTRIBUTE_NAME VARCHAR2 (30) Yes Name of the attribute for which the rule is being defined.
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book type Code.This would store Corporate Book Code OR Tax Book Or Budget Book Code associated with the Corporate book.
INCLUDE_HIERARCHY_FLAG VARCHAR2 (1) Yes Indicates whether to look at the Hierarchy for deriving asset attribute values. Can have values 'Y', 'N'
INCLUDE_LEVEL VARCHAR2 (30)
Indicates level of the hierarchy from which the asset attribute value would be derived.
INCLUDE_ASSET_CATG_LIFE_FLAG VARCHAR2 (1)
Indicates whether to look at Life in Months specified on the Asset Category to derive Life End Date on the asset. Can Have values 'Y' - 'N' - Note : This only applies for Life End Date Attribute.
INCLUDE_CATG_END_DATE_FLAG VARCHAR2 (1)
Indicates whether to look at Final End Date specified on the Asset Category to derive Life End Date on the asset. Can Have values 'Y' - 'N' - Note : This only applies for Life End Date Attribute.
INCLUDE_ASSET_END_DATE_FLAG VARCHAR2 (1)
Indicates whether to look at End Date on the asset itself to derive Life End Date on the asset. Can Have values 'Y' - 'N' - Note : This only applies for Life End Date Attribute.
INCLUDE_LEASE_END_DATE_FLAG VARCHAR2 (1)
Indicates whether to look at End Date on the Lease associated with the Asset to derive Life End Date on the asset. Can Have values 'Y' - 'N' -Note : This only applies for Life End Date Attribute.
BASIS_CODE VARCHAR2 (30)
Stores the rule which will be applied to determine how attribute value is calculated if you have multiple sources from which the value is read . Can have valuesMax - Maximum value is selectedMin - Minimum value is selectedAvg - Average value is selectedMedian - Median value is selectedNote : This only applies for Life End Date Attribute
PRECEDENCE_LEVEL VARCHAR2 (30)
To specify a level which takes precedence if that level has a value.Note : This only applies for Life End Date Attribute
OVERRIDE_ALLOWED_FLAG VARCHAR2 (1)
Flag to control if you can override value of attribute at the asset level. This can have values1. No - Not Allowed2. Yes - Allowed
TARGET_FLAG VARCHAR2 (1)
Flag to indicate if attribute value would be first derived on the lowest level and then cascaded to the individual assets attached to the lowest level or directly.
CREATED_BY NUMBER
Yes Standard WHO column.
CREATION_DATE DATE
Yes Standard WHO column.
LAST_UPDATED_BY NUMBER
Yes Standard WHO column.
LAST_UPDATE_DATE DATE
Yes Standard WHO column.
LAST_UPDATE_LOGIN NUMBER
Yes Standard WHO column.
Query Text

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


SELECT HIERARCHY_RULE_SET_ID
,      ATTRIBUTE_NAME
,      BOOK_TYPE_CODE
,      INCLUDE_HIERARCHY_FLAG
,      INCLUDE_LEVEL
,      INCLUDE_ASSET_CATG_LIFE_FLAG
,      INCLUDE_CATG_END_DATE_FLAG
,      INCLUDE_ASSET_END_DATE_FLAG
,      INCLUDE_LEASE_END_DATE_FLAG
,      BASIS_CODE
,      PRECEDENCE_LEVEL
,      OVERRIDE_ALLOWED_FLAG
,      TARGET_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FA.FA_HIERARCHY_RULE_DETAILS;

Dependencies

[top of page]

FA.FA_HIERARCHY_RULE_DETAILS does not reference any database object

FA.FA_HIERARCHY_RULE_DETAILS is referenced by following:

SchemaFA
ViewFA_HIERARCHY_RULE_DETAILS#