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

TABLE: GMD.GMD_EVENT_SPEC_DISP

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


OPM Quality Event Specification Display


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMD_EVENT_SPEC_DISP_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_SPEC_DISP_ID
GMD_EVENT_SPEC_DISP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSAMPLING_EVENT_ID
Columns
Name Datatype Length Mandatory Comments
EVENT_SPEC_DISP_ID NUMBER
Yes Event Specification Display Identifier
SAMPLING_EVENT_ID NUMBER
Yes Sampling Event Identification
SPEC_ID NUMBER

Specification Identifier
SPEC_VR_ID NUMBER

Specification Validity Rule
DISPOSITION VARCHAR2 (3) Yes Disposition
SPEC_USED_FOR_LOT_ATTRIB_IND VARCHAR2 (1)
Spec use for lot attribute
DELETE_MARK NUMBER (5) Yes Logical delete indicator. Values 1=deleted, 0=undelete
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
Query Text

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


SELECT EVENT_SPEC_DISP_ID
,      SAMPLING_EVENT_ID
,      SPEC_ID
,      SPEC_VR_ID
,      DISPOSITION
,      SPEC_USED_FOR_LOT_ATTRIB_IND
,      DELETE_MARK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GMD.GMD_EVENT_SPEC_DISP;

Dependencies

[top of page]

GMD.GMD_EVENT_SPEC_DISP does not reference any database object

GMD.GMD_EVENT_SPEC_DISP is referenced by following:

SchemaGMD
ViewGMD_EVENT_SPEC_DISP#