VIEW: CN.CN_PERIOD_STATUSES_ALL#

Source

View Text - Preformatted

select PERIOD_ID PERIOD_ID, PERIOD_NAME PERIOD_NAME, PERIOD_TYPE_ID PERIOD_TYPE_ID, PERIOD_STATUS PERIOD_STATUS, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE, PROGRAM_ID PROGRAM_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORG_ID ORG_ID, QUARTER_NUM QUARTER_NUM, PERIOD_YEAR PERIOD_YEAR, FORECAST_FLAG FORECAST_FLAG, START_DATE START_DATE, END_DATE END_DATE, PERIOD_TYPE PERIOD_TYPE, CALENDAR_ID CALENDAR_ID, PERIOD_SET_ID PERIOD_SET_ID, PERIOD_SET_NAME PERIOD_SET_NAME, FREEZE_FLAG FREEZE_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID from "CN"."CN_PERIOD_STATUSES_ALL"

View Text - HTML Formatted

SELECT PERIOD_ID PERIOD_ID
, PERIOD_NAME PERIOD_NAME
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, PERIOD_STATUS PERIOD_STATUS
, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE
, PROGRAM_ID PROGRAM_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORG_ID ORG_ID
, QUARTER_NUM QUARTER_NUM
, PERIOD_YEAR PERIOD_YEAR
, FORECAST_FLAG FORECAST_FLAG
, START_DATE START_DATE
, END_DATE END_DATE
, PERIOD_TYPE PERIOD_TYPE
, CALENDAR_ID CALENDAR_ID
, PERIOD_SET_ID PERIOD_SET_ID
, PERIOD_SET_NAME PERIOD_SET_NAME
, FREEZE_FLAG FREEZE_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "CN"."CN_PERIOD_STATUSES_ALL"