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

VIEW: GMA.GMA_PROCDATA_WF#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
WF_ITEM_TYPE VARCHAR2 (8)
PROCESS_NAME VARCHAR2 (30)
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)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_DATE DATE

ENABLE_FLAG VARCHAR2 (1)
SORT_ORDER NUMBER (5)
Query Text

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


SELECT WF_ITEM_TYPE
,      PROCESS_NAME
,      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
,      ENABLE_FLAG
,      SORT_ORDER
FROM GMA.GMA_PROCDATA_WF#;

Dependencies

[top of page]

GMA.GMA_PROCDATA_WF# references the following:

SchemaGMA
TableGMA_PROCDATA_WF
GMA.GMA_PROCDATA_WF# is referenced by following:

SchemaAPPS
SynonymGMA_PROCDATA_WF