[Home] [Help] [Dependency Information]
Object Name: | JTF_RS_GROUPS_DENORM |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_RS_GROUPS_DENORM |
Subobject Name: | |
Status: | VALID |
This is a denormalized table for Group. It stores information about parent group and immediate parent flag.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_RS_GROUPS_DENORM_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DENORM_GRP_ID |
JTF_RS_GROUPS_DENORM_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARENT_GROUP_ID
IMMEDIATE_PARENT_FLAG DENORM_LEVEL START_DATE_ACTIVE END_DATE_ACTIVE GROUP_ID |
JTF_RS_GROUPS_DENORM_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
GROUP_ID
PARENT_GROUP_ID START_DATE_ACTIVE END_DATE_ACTIVE |
JTF_RS_GROUPS_DENORM_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ACTUAL_PARENT_ID
DENORM_LEVEL |
JTF_RS_GROUPS_DENORM_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTIVE_FLAG |
JTF_RS_GROUPS_DENORM_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LATEST_RELATIONSHIP_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DENORM_GRP_ID | NUMBER | Yes | Unique Identifier for Group Denorm | |
GROUP_ID | NUMBER | Yes | Group identifier | |
PARENT_GROUP_ID | NUMBER | Yes | Parent Group identifier | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
IMMEDIATE_PARENT_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the value in PARENT_GROUP_ID is the identifier of immediate parent group. |
START_DATE_ACTIVE | DATE | Date this group becomes active | ||
END_DATE_ACTIVE | DATE | Date this group becomes inactive | ||
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 definition column. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Sequential number used for database locking control when using HTML as a user interface | |
SECURITY_GROUP_ID | NUMBER | Column used for Applications Hosting purposes | ||
DENORM_LEVEL | NUMBER | Column to show the depth of the hierarchy | ||
ACTUAL_PARENT_ID | NUMBER | Column to show actual parent of the group | ||
ACTIVE_FLAG | VARCHAR2 | (1) | This column will be populated by concurrent program. Valid values are "Y" and "NULL". It will tell if the group relation is active or not | |
LATEST_RELATIONSHIP_FLAG | VARCHAR2 | (30) | This column will be populated by concurrent program, 'Maintain Current Groups and Roles'. Valid values are "Y" and "NULL". If the value is 'Y', it means this is the latest (expired as well as active) parent relationship. |
Cut, paste (and edit) the following text to query this object:
SELECT DENORM_GRP_ID
, GROUP_ID
, PARENT_GROUP_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, IMMEDIATE_PARENT_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, DENORM_LEVEL
, ACTUAL_PARENT_ID
, ACTIVE_FLAG
, LATEST_RELATIONSHIP_FLAG
FROM JTF.JTF_RS_GROUPS_DENORM;
JTF.JTF_RS_GROUPS_DENORM does not reference any database object
JTF.JTF_RS_GROUPS_DENORM is referenced by following:
|
|
|