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

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
ATTRIBUTE_NAME VARCHAR2 (30) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
INCLUDE_HIERARCHY_FLAG VARCHAR2 (1) Yes
INCLUDE_LEVEL VARCHAR2 (30)
INCLUDE_ASSET_CATG_LIFE_FLAG VARCHAR2 (1)
INCLUDE_CATG_END_DATE_FLAG VARCHAR2 (1)
INCLUDE_ASSET_END_DATE_FLAG VARCHAR2 (1)
INCLUDE_LEASE_END_DATE_FLAG VARCHAR2 (1)
BASIS_CODE VARCHAR2 (30)
PRECEDENCE_LEVEL VARCHAR2 (30)
OVERRIDE_ALLOWED_FLAG VARCHAR2 (1)
TARGET_FLAG VARCHAR2 (1)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
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:

SchemaAPPS
SynonymFA_HIERARCHY_RULE_DETAILS