VIEW: PA.PA_TIMELINE_ROW_LABEL#

Source

View Text - Preformatted

select ROW_LABEL_ID ROW_LABEL_ID, ROW_LABEL_TYPE ROW_LABEL_TYPE, PROJECT_ID PROJECT_ID, PROJECT_NUMBER PROJECT_NUMBER, PROJECT_NAME PROJECT_NAME, ASSIGNMENT_ID ASSIGNMENT_ID, ASSIGNMENT_NAME ASSIGNMENT_NAME, ASSIGNMENT_STATUS ASSIGNMENT_STATUS, ASSIGNMENT_START_DATE ASSIGNMENT_START_DATE, ASSIGNMENT_END_DATE ASSIGNMENT_END_DATE, RESOURCE_ID RESOURCE_ID, RESOURCE_NAME RESOURCE_NAME, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_NAME ORGANIZATION_NAME, RESOURCE_MGR_NAME RESOURCE_MGR_NAME, SCH_UPD_PENDING_FLAG SCH_UPD_PENDING_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PA"."PA_TIMELINE_ROW_LABEL"

View Text - HTML Formatted

SELECT ROW_LABEL_ID ROW_LABEL_ID
, ROW_LABEL_TYPE ROW_LABEL_TYPE
, PROJECT_ID PROJECT_ID
, PROJECT_NUMBER PROJECT_NUMBER
, PROJECT_NAME PROJECT_NAME
, ASSIGNMENT_ID ASSIGNMENT_ID
, ASSIGNMENT_NAME ASSIGNMENT_NAME
, ASSIGNMENT_STATUS ASSIGNMENT_STATUS
, ASSIGNMENT_START_DATE ASSIGNMENT_START_DATE
, ASSIGNMENT_END_DATE ASSIGNMENT_END_DATE
, RESOURCE_ID RESOURCE_ID
, RESOURCE_NAME RESOURCE_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_NAME ORGANIZATION_NAME
, RESOURCE_MGR_NAME RESOURCE_MGR_NAME
, SCH_UPD_PENDING_FLAG SCH_UPD_PENDING_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PA"."PA_TIMELINE_ROW_LABEL"