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

TABLE: GMO.GMO_LABEL_HISTORY

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


Stores Label Printing History


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMO_LABEL_HISTORY_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLABEL_ID
Columns
Name Datatype Length Mandatory Comments
LABEL_ID NUMBER
Yes Label ID
ENTITY_NAME VARCHAR2 (32) Yes Event Name
ENTITY_KEY VARCHAR2 (32) Yes Event Key
WMS_BUSINESSFLOW_CODE NUMBER
Yes Label Business Flow Code
WMS_BUSINESSFLOW_TRANS_ID VARCHAR2 (32) Yes Business Flow Transaction ID
TRANSACTION_TYPE VARCHAR2 (32)
Transaction Type
REQUESTER NUMBER
Yes Requester
REQUESTED_DATE DATE
Yes Requested Date
ERECORD_ID NUMBER

eRecord ID
STATUS VARCHAR2 (32) Yes Status
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
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 LABEL_ID
,      ENTITY_NAME
,      ENTITY_KEY
,      WMS_BUSINESSFLOW_CODE
,      WMS_BUSINESSFLOW_TRANS_ID
,      TRANSACTION_TYPE
,      REQUESTER
,      REQUESTED_DATE
,      ERECORD_ID
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GMO.GMO_LABEL_HISTORY;

Dependencies

[top of page]

GMO.GMO_LABEL_HISTORY does not reference any database object

GMO.GMO_LABEL_HISTORY is referenced by following:

SchemaGMO
ViewGMO_LABEL_HISTORY#