[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_SHORTHAND_FLEX_ALIASES |
|---|---|
| Object Type: | TABLE |
| Owner: | APPLSYS |
| FND Design Data: |  FND.FND_SHORTHAND_FLEX_ALIASES
|
| Subobject Name: | |
| Status: | VALID |
FND_SHORTHAND_FLEX_ALIASES stores alias information for shorthand
flexfield entry. Each row includes the name and description of the
shorthand alias, as well as values that identify the key flexfield
structure to which the alias belongs. Each row also includes
information that indicates whether this alias is currently valid,
as well as the concatenated key flexfield segment values that make
up the shorthand entry (either full or partial concatenated segment
string).
The structure's segment separator character separates the segment
values. You need one row for each defined shorthand alias. Oracle
Application Object Library uses this information to provide users
with a quick way to enter key flexfield data.
.
.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FND_SHORTHAND_FLEX_ALIASES_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 APPLICATION_ID
ID_FLEX_CODE
ID_FLEX_NUM
ALIAS_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| APPLICATION_ID | NUMBER | (10) | Yes | select t.application_id from fnd_tables t, fnd_id_flexs f where t.table_name = f.application_table_name and f.id_flex_code = fnd_shorthand_flex_aliases.id_flex_code and rownum = 1 |
| ID_FLEX_CODE | VARCHAR2 | (4) | Yes | Key flexfield code |
| ID_FLEX_NUM | NUMBER | (15) | Yes | Key flexfield structure number |
| ALIAS_NAME | VARCHAR2 | (30) | Yes | Name of the shorthand alias |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| CONCATENATED_SEGMENTS | VARCHAR2 | (2000) | Yes | The concatenated key flexfield segment values that is represented by the shorthand alias |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the shorthand alias is enabled |
| DESCRIPTION | VARCHAR2 | (240) | Yes | Description |
| START_DATE_ACTIVE | DATE | The date the shorthand alias becomes active | ||
| END_DATE_ACTIVE | DATE | The date the shorthand alias expires | ||
| 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) | Attribute category |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, ID_FLEX_CODE
, ID_FLEX_NUM
, ALIAS_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CONCATENATED_SEGMENTS
, ENABLED_FLAG
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
FROM APPLSYS.FND_SHORTHAND_FLEX_ALIASES;
APPLSYS.FND_SHORTHAND_FLEX_ALIASES does not reference any database object
APPLSYS.FND_SHORTHAND_FLEX_ALIASES is referenced by following:
APPS
FND_SHORTHAND_FLEX_ALIASES
|
|
|
|