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

TABLE: JTF.JTF_RS_GRP_DEN_LTST_REL_2_TMP

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

This is temporary table for fetching all those denorm_grp_ids which has to be updated with latest_relationship_flag = "Y" in JTF_RS_GROUPS_DENORM Table. This is used in "Maintain Current Groups and Roles" concurrant program.

Temporary Table Details

JTF.JTF_RS_GRP_DEN_LTST_REL_2_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
Indexes
Index Type Uniqueness Tablespace Column
JTF_RS_GRP_DEN_LTST_REL_2_N1 NORMAL UNIQUE Tablespace ColumnDENORM_GRP_ID
Columns
Name Datatype Length Mandatory Comments
DENORM_GRP_ID NUMBER

Denorm Group Id of JTF_RS_GROUPS_DENORM table which has to be updated for latest_relationship_flag = "Y"
Query Text

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


SELECT DENORM_GRP_ID
FROM JTF.JTF_RS_GRP_DEN_LTST_REL_2_TMP;

Dependencies

[top of page]

JTF.JTF_RS_GRP_DEN_LTST_REL_2_TMP does not reference any database object

JTF.JTF_RS_GRP_DEN_LTST_REL_2_TMP is referenced by following:

SchemaAPPS
SynonymJTF_RS_GRP_DEN_LTST_REL_2_TMP