[Home] [Help] [Dependency Information]
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.
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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 |
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;
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:
|
|
|