[Home] [Help] [Dependency Information]
Object Name: | GMO_OPERATOR_CERT_TRANS |
---|---|
Object Type: | TABLE |
Owner: | GMO |
FND Design Data: | GMO.GMO_OPERATOR_CERT_TRANS |
Subobject Name: | |
Status: | VALID |
Operator Certification Transaction Instances
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMO_OPERATOR_CERT_TRANS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | OPERATOR_CERTIFICATE_ID |
GMO_OPERATOR_CERT_TRANS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OPERATOR_CERTIFICATE_ID
USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPERATOR_CERTIFICATE_ID | NUMBER | Yes | OPERATOR_CERTIFICATE_ID | |
HEADER_ID | NUMBER | Yes | header_id from GMO_OPERT_CERT_HEADER | |
TRANSACTION_ID | VARCHAR2 | (240) | TRANSACTION_ID is TRANSACTION which it is applicable | |
USER_ID | NUMBER | Yes | User_id of the Operator | |
COMMENTS | VARCHAR2 | (240) | COMMENTS for this override | |
OVERRIDER_ID | NUMBER | OVERRIDER_ID for this qualification | ||
USER_KEY_LABEL_PRODUCT | VARCHAR2 | (30) | PRODUCT for this transaction | |
USER_KEY_LABEL_TOKEN | VARCHAR2 | (240) | TOKEN for this transaction | |
USER_KEY_VALUE | VARCHAR2 | (240) | Value for this transaction | |
ERECORD_ID | NUMBER | ERECORD_ID for this transaction | ||
TRANS_OBJECT_ID | NUMBER | Object for this transaction | ||
STATUS | VARCHAR2 | (1) | STATUS for this transaction | |
EVENT_KEY | VARCHAR2 | (30) | EVENT_KEY for this transaction | |
EVENT_NAME | VARCHAR2 | (240) | EVENT_NAME for this transaction | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT OPERATOR_CERTIFICATE_ID
, HEADER_ID
, TRANSACTION_ID
, USER_ID
, COMMENTS
, OVERRIDER_ID
, USER_KEY_LABEL_PRODUCT
, USER_KEY_LABEL_TOKEN
, USER_KEY_VALUE
, ERECORD_ID
, TRANS_OBJECT_ID
, STATUS
, EVENT_KEY
, EVENT_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM GMO.GMO_OPERATOR_CERT_TRANS;
GMO.GMO_OPERATOR_CERT_TRANS does not reference any database object
GMO.GMO_OPERATOR_CERT_TRANS is referenced by following:
|
|
|