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

TABLE: JTF.JTF_RS_GRP_DEN_LTST_REL_1_TMP

Object Details
Object Name: JTF_RS_GRP_DEN_LTST_REL_1_TMP
Object Type: TABLE
Owner: JTF
Subobject Name:
Status: VALID

This is temporary table for fetching all those groups who currently do not have active parent group. This is used in "Maintain Current Groups and Roles" concurrant program to populate the latest_relationship_flag in JTF_RS_GROUPS_DENORM_TABLE.

Temporary Table Details

JTF.JTF_RS_GRP_DEN_LTST_REL_1_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
CHILD_GROUP_ID NUMBER

Group Id of group who currently do not have a parent group.
PARENT_GROUP_ID NUMBER

Group Id of group which was last parent group of group id stored in column child_group_id
START_DATE_ACTIVE DATE

Start Date of group relation between parent and child group
END_DATE_ACTIVE DATE

End Date of group relation between parent and child group
Query Text

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


SELECT CHILD_GROUP_ID
,      PARENT_GROUP_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM JTF.JTF_RS_GRP_DEN_LTST_REL_1_TMP;

Dependencies

[top of page]

JTF.JTF_RS_GRP_DEN_LTST_REL_1_TMP does not reference any database object

JTF.JTF_RS_GRP_DEN_LTST_REL_1_TMP is referenced by following:

SchemaAPPS
SynonymJTF_RS_GRP_DEN_LTST_REL_1_TMP