[Home] [Help] [Dependency Information]
Object Name: | FND_SEG_RPT_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_SEG_RPT_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
FND_SEG_RPT_ATTRIBUTES stores information about segment
attributes that are used by Oracle Government General Ledger for
reporting purposes. Each row includes the application identifier,
the key flexfield code and structure number, the key flexfield
segment name and number, and a value identifying the value
set used by the key flexfield segment.
This table is used only by Oracle Government General Ledger.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_SEG_RPT_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
ID_FLEX_CODE ID_FLEX_NUM ATTR_SEGMENT_NAME |
FND_SEG_RPT_ATTRIBUTES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
ID_FLEX_CODE ID_FLEX_NUM APPLICATION_COLUMN_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (10) | Yes | Application identifier |
ID_FLEX_CODE | VARCHAR2 | (4) | Yes | Key flexfield code |
ID_FLEX_NUM | NUMBER | (15) | Yes | Key flexfield structure number |
APPLICATION_COLUMN_NAME | VARCHAR2 | (30) | Yes | Column name |
SEGMENT_NUM | NUMBER | (3) | Yes | Segment number |
FLEX_VALUE_SET_ID | NUMBER | (10) | Yes | Flexfield value set identifier |
USER_COLUMN_NAME | VARCHAR2 | (30) | Yes | Segment title |
INDEX_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the table column for this segment is indexed |
FORM_LEFT_PROMPT | VARCHAR2 | (80) | Yes | From left prompt |
FORM_ABOVE_PROMPT | VARCHAR2 | (80) | Yes | Above prompt |
DISPLAY_SIZE | NUMBER | (3) | Yes | Display size |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Enabled flag |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (10) | Yes | Standard Who column |
SEGMENT_NAME | VARCHAR2 | (15) | Yes | Segment name |
ATTR_VALUE_SET_ID | NUMBER | (10) | Yes | Attribute value set identifier |
COLUMN_TYPE | VARCHAR2 | (1) | Column data type | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
SEQUENCE | NUMBER | Sequence | ||
FLEX_VALUE_SET_APPLICATION_ID | NUMBER | (10) | Flexfield value set application identifier | |
ATTR_SEGMENT_NAME | VARCHAR2 | (30) | Attribute segment name | |
ATTR_COLUMN_ID | NUMBER | (15) | Attribute column identifier | |
TABLE_ID | NUMBER | (10) | Table identifier | |
ATTRIBUTE_NUM | VARCHAR2 | (30) | Attribute number |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, ID_FLEX_CODE
, ID_FLEX_NUM
, APPLICATION_COLUMN_NAME
, SEGMENT_NUM
, FLEX_VALUE_SET_ID
, USER_COLUMN_NAME
, INDEX_FLAG
, FORM_LEFT_PROMPT
, FORM_ABOVE_PROMPT
, DISPLAY_SIZE
, ENABLED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SEGMENT_NAME
, ATTR_VALUE_SET_ID
, COLUMN_TYPE
, DESCRIPTION
, SEQUENCE
, FLEX_VALUE_SET_APPLICATION_ID
, ATTR_SEGMENT_NAME
, ATTR_COLUMN_ID
, TABLE_ID
, ATTRIBUTE_NUM
FROM APPLSYS.FND_SEG_RPT_ATTRIBUTES;
APPLSYS.FND_SEG_RPT_ATTRIBUTES does not reference any database object
APPLSYS.FND_SEG_RPT_ATTRIBUTES is referenced by following:
|
|
|