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

TABLE: GMO.GMO_OPERT_CERT_DETAIL

Object Details
Object Name: GMO_OPERT_CERT_DETAIL
Object Type: TABLE
Owner: GMO
FND Design Data: TableGMO.GMO_OPERT_CERT_DETAIL
Subobject Name:
Status: VALID


Operator Certification Details


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMO_OPERT_CERT_DETAIL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDETAIL_ID
GMO_OPERT_CERT_DETAIL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDETAIL_ID
ColumnHEADER_ID
ColumnQUALIFICATION_ID
ColumnQUALIFICATION_TYPE
Columns
Name Datatype Length Mandatory Comments
DETAIL_ID NUMBER
Yes Unique Identifier
HEADER_ID NUMBER
Yes Parent Identifier
QUALIFICATION_ID NUMBER
Yes Qualifiaction ID is Qualifiaction which it is applicable
QUALIFICATION_TYPE NUMBER
Yes Identifies Qualification is Certificate or Competecy
PROFICIENCY_LEVEL_ID NUMBER

Proficiency Level for this Qualification
FROM_DATE DATE
Yes From date for this qualification
TO_DATE DATE

To date for this qualification
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
Query Text

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


SELECT DETAIL_ID
,      HEADER_ID
,      QUALIFICATION_ID
,      QUALIFICATION_TYPE
,      PROFICIENCY_LEVEL_ID
,      FROM_DATE
,      TO_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GMO.GMO_OPERT_CERT_DETAIL;

Dependencies

[top of page]

GMO.GMO_OPERT_CERT_DETAIL does not reference any database object

GMO.GMO_OPERT_CERT_DETAIL is referenced by following:

SchemaAPPS
SynonymGMO_OPERT_CERT_DETAIL