VIEW: GMA.GMA_ACTDATA_WF#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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