VIEW: OKS.OKS_PM_STREAM_LEVELS#

Source

View Text - Preformatted

select ID ID, CLE_ID CLE_ID, DNZ_CHR_ID DNZ_CHR_ID, ACTIVITY_LINE_ID ACTIVITY_LINE_ID, SEQUENCE_NUMBER SEQUENCE_NUMBER, NUMBER_OF_OCCURENCES NUMBER_OF_OCCURENCES, START_DATE START_DATE, END_DATE END_DATE, FREQUENCY FREQUENCY, FREQUENCY_UOM FREQUENCY_UOM, OFFSET_DURATION OFFSET_DURATION, OFFSET_UOM OFFSET_UOM, AUTOSCHEDULE_YN AUTOSCHEDULE_YN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1, ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1, ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE from "OKS"."OKS_PM_STREAM_LEVELS"

View Text - HTML Formatted

SELECT ID ID
, CLE_ID CLE_ID
, DNZ_CHR_ID DNZ_CHR_ID
, ACTIVITY_LINE_ID ACTIVITY_LINE_ID
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, NUMBER_OF_OCCURENCES NUMBER_OF_OCCURENCES
, START_DATE START_DATE
, END_DATE END_DATE
, FREQUENCY FREQUENCY
, FREQUENCY_UOM FREQUENCY_UOM
, OFFSET_DURATION OFFSET_DURATION
, OFFSET_UOM OFFSET_UOM
, AUTOSCHEDULE_YN AUTOSCHEDULE_YN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1
, ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE
FROM "OKS"."OKS_PM_STREAM_LEVELS"