Skip to content

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

TABLE: JTF.JTF_RS_DBI_DENORM_RES_GROUPS

Object Details
Object Name: JTF_RS_DBI_DENORM_RES_GROUPS
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_RS_DBI_DENORM_RES_GROUPS
Subobject Name:
Status: VALID

This table contains denormalized resource and group relation for manager and admins. This is specifically used for DBI product. The view JTF_RS_DBI_RES_GRP_VL on top of this will make this table readable.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_RS_DBI_DENORM_RES_GRPS_FN1 FUNCTION-BASED NORMAL NONUNIQUE Tablespace ColumnTO_CHAR("ID")
JTF_RS_DBI_DENORM_RES_GRPS_N1 NORMAL NONUNIQUE Tablespace ColumnUSER_ID
ColumnCURRENT_ID
ColumnID
ColumnUSAGE
JTF_RS_DBI_DENORM_RES_GRPS_N2 NORMAL NONUNIQUE Tablespace ColumnID_FOR_GRP_MEM
ColumnUSAGE
Columns
Name Datatype Length Mandatory Comments
DENORM_ID NUMBER
Yes This is unique identifier column
ID NUMBER

This column contains group id which will be displayed in view JTF_RS_DBI_RES_GRP_VL
CURRENT_ID NUMBER

This column contains group id for which data will be queried in view JTF_RS_DBI_RES_GRP_VL
PARENT_ID NUMBER

This column contains parent group id for corresponding id column
DENORM_LEVEL NUMBER

This column contains the denorm level of the id column
START_DATE DATE

This column contains start date of relation between group id (id) and its parent (parent_id)
END_DATE DATE

This column contains end date of relation between group id (id) and its parent (parent_id)
USER_ID NUMBER

This column contains group managers / administrators user id
RESOURCE_ID NUMBER

This column contains group managers resource id
DEBUG_COLUMN VARCHAR2 (250)
This column contains the Debug information
VALUE VARCHAR2 (60)
This column contains the prefixes needed for Group Name which will be fetched at run time in the view
ID_FOR_GRP_MEM VARCHAR2 (240)
This column stores the Id in format "Resource Id.Group Id". For Group Members, Id column will be null and this column will be aliased as Id in the view JTF_RS_DBI_RES_GRP_VL
GRP_MEM_RESOURCE_ID NUMBER

This column stores the resource id of the group members of the group being queried.
MEM_FLAG VARCHAR2 (30)
This column indicates if the row is group member row. If value is "Y", the row refers to a group member. If the value is "N", the row refers to a group.
MEM_STATUS VARCHAR2 (30)
Group Member Status. If the row belongs to a group member, this column tells if the group member is active or inactive. Valid values are "A" and "I".
ACTIVE_GRP_REL_ONLY VARCHAR2 (30)
This column indicates if the group relationship is active/expired. If value is "Y" then, the relationship is active. If the value is "N" then, relationship is latest but expired.
USAGE VARCHAR2 (60)
This column indicates usage of the group.
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
SECURITY_GROUP_ID NUMBER

Security Group Identifier - For Internal Use only.
Query Text

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


SELECT DENORM_ID
,      ID
,      CURRENT_ID
,      PARENT_ID
,      DENORM_LEVEL
,      START_DATE
,      END_DATE
,      USER_ID
,      RESOURCE_ID
,      DEBUG_COLUMN
,      VALUE
,      ID_FOR_GRP_MEM
,      GRP_MEM_RESOURCE_ID
,      MEM_FLAG
,      MEM_STATUS
,      ACTIVE_GRP_REL_ONLY
,      USAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
FROM JTF.JTF_RS_DBI_DENORM_RES_GROUPS;

Dependencies

[top of page]

JTF.JTF_RS_DBI_DENORM_RES_GROUPS does not reference any database object

JTF.JTF_RS_DBI_DENORM_RES_GROUPS is referenced by following:

SchemaJTF
ViewJTF_RS_DBI_DENORM_RES_GROUPS#