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


TABLE: GMD.GMD_SPEC_MAPPING_GTMP

Object Details
Object Name: GMD_SPEC_MAPPING_GTMP
Object Type: TABLE
Owner: GMD
FND Design Data: TableGMD.GMD_SPEC_MAPPING_GTMP
Subobject Name:
Status: VALID

Temporary Table Details

GMD.GMD_SPEC_MAPPING_GTMP 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$TRANSACTION. 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
QC_SPEC_ID NUMBER (15)
SPEC_ID NUMBER (15)
TEST_ID NUMBER (15)
QC_REC_TYPE VARCHAR2 (4)
SPEC_VR_ID NUMBER (15)
START_DATE DATE

END_DATE DATE

VR_SPEC_ID NUMBER (15)
Query Text

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


SELECT QC_SPEC_ID
,      SPEC_ID
,      TEST_ID
,      QC_REC_TYPE
,      SPEC_VR_ID
,      START_DATE
,      END_DATE
,      VR_SPEC_ID
FROM GMD.GMD_SPEC_MAPPING_GTMP;

Dependencies

[top of page]

GMD.GMD_SPEC_MAPPING_GTMP does not reference any database object

GMD.GMD_SPEC_MAPPING_GTMP is referenced by following:

SchemaAPPS
SynonymGMD_SPEC_MAPPING_GTMP