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

VIEW: GMA.GMA_ACTDATA_WF#

Object Details
Object Name: GMA_ACTDATA_WF#
Object Type: VIEW
Owner: GMA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ID NUMBER (10) Yes
COLUMN_NAME1 VARCHAR2 (32)
COLUMN_VALUE1 VARCHAR2 (240)
COLUMN_NAME2 VARCHAR2 (32)
COLUMN_VALUE2 VARCHAR2 (240)
COLUMN_NAME3 VARCHAR2 (32)
COLUMN_VALUE3 VARCHAR2 (240)
COLUMN_NAME4 VARCHAR2 (32)
COLUMN_VALUE4 VARCHAR2 (240)
COLUMN_NAME5 VARCHAR2 (32)
COLUMN_VALUE5 VARCHAR2 (240)
COLUMN_NAME6 VARCHAR2 (32)
COLUMN_VALUE6 VARCHAR2 (240)
COLUMN_NAME7 VARCHAR2 (32)
COLUMN_VALUE7 VARCHAR2 (240)
COLUMN_NAME8 VARCHAR2 (32)
COLUMN_VALUE8 VARCHAR2 (240)
COLUMN_NAME9 VARCHAR2 (32)
COLUMN_VALUE9 VARCHAR2 (240)
COLUMN_NAME10 VARCHAR2 (32)
COLUMN_VALUE10 VARCHAR2 (240)
ROLE VARCHAR2 (30)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
SORT_ORDER NUMBER (5)
ENABLE_FLAG VARCHAR2 (1)
Query Text

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


SELECT ACTIVITY_ID
,      COLUMN_NAME1
,      COLUMN_VALUE1
,      COLUMN_NAME2
,      COLUMN_VALUE2
,      COLUMN_NAME3
,      COLUMN_VALUE3
,      COLUMN_NAME4
,      COLUMN_VALUE4
,      COLUMN_NAME5
,      COLUMN_VALUE5
,      COLUMN_NAME6
,      COLUMN_VALUE6
,      COLUMN_NAME7
,      COLUMN_VALUE7
,      COLUMN_NAME8
,      COLUMN_VALUE8
,      COLUMN_NAME9
,      COLUMN_VALUE9
,      COLUMN_NAME10
,      COLUMN_VALUE10
,      ROLE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      SORT_ORDER
,      ENABLE_FLAG
FROM GMA.GMA_ACTDATA_WF#;

Dependencies

[top of page]

GMA.GMA_ACTDATA_WF# references the following:

SchemaGMA
TableGMA_ACTDATA_WF
GMA.GMA_ACTDATA_WF# is referenced by following:

SchemaAPPS
SynonymGMA_ACTDATA_WF