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

TABLE: GMP.GMP_RESOURCE_DEVICE_MESSAGES

Object Details
Object Name: GMP_RESOURCE_DEVICE_MESSAGES
Object Type: TABLE
Owner: GMP
FND Design Data: TableGMP.GMP_RESOURCE_DEVICE_MESSAGES
Subobject Name:
Status: VALID


Resource Parameter to Device Response Messages Mapping Table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMP_RESOURCE_DEVICE_MESSAGES_U NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnDEVICE_ID
ColumnRESP_COMP_CODE_VALUE
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Yes Unique Identifier of resource
DEVICE_ID NUMBER
Yes Unique Identifier of Device
PROCESS_PARAM_ID NUMBER
Yes Unique identifier of the Process Parameter associated with the resource
RESP_COMP_CODE_VALUE NUMBER
Yes Response Value mapped to the process parameter of the resource
RESP_COMP_CODE_UOM NUMBER
Yes Response UOM
EVENT_ID NUMBER

Event ID
CREATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
Query Text

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


SELECT RESOURCE_ID
,      DEVICE_ID
,      PROCESS_PARAM_ID
,      RESP_COMP_CODE_VALUE
,      RESP_COMP_CODE_UOM
,      EVENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM GMP.GMP_RESOURCE_DEVICE_MESSAGES;

Dependencies

[top of page]

GMP.GMP_RESOURCE_DEVICE_MESSAGES does not reference any database object

GMP.GMP_RESOURCE_DEVICE_MESSAGES is referenced by following:

SchemaAPPS
SynonymGMP_RESOURCE_DEVICE_MESSAGES