VIEW: PA.PA_PROJ_ELEM_VER_STRUCTURE#

Source

View Text - Preformatted

select PEV_STRUCTURE_ID PEV_STRUCTURE_ID, ELEMENT_VERSION_ID ELEMENT_VERSION_ID, VERSION_NUMBER VERSION_NUMBER, NAME NAME, PROJECT_ID PROJECT_ID, PROJ_ELEMENT_ID PROJ_ELEMENT_ID, CURRENT_FLAG CURRENT_FLAG, ORIGINAL_FLAG ORIGINAL_FLAG, LATEST_EFF_PUBLISHED_FLAG LATEST_EFF_PUBLISHED_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, DESCRIPTION DESCRIPTION, EFFECTIVE_DATE EFFECTIVE_DATE, PUBLISHED_DATE PUBLISHED_DATE, PUBLISHED_BY_PERSON_ID PUBLISHED_BY_PERSON_ID, CURRENT_BASELINE_DATE CURRENT_BASELINE_DATE, CURRENT_BASELINE_PERSON_ID CURRENT_BASELINE_PERSON_ID, ORIGINAL_BASELINE_DATE ORIGINAL_BASELINE_DATE, ORIGINAL_BASELINE_PERSON_ID ORIGINAL_BASELINE_PERSON_ID, LOCK_STATUS_CODE LOCK_STATUS_CODE, LOCKED_BY_PERSON_ID LOCKED_BY_PERSON_ID, LOCKED_DATE LOCKED_DATE, STATUS_CODE STATUS_CODE, WF_STATUS_CODE WF_STATUS_CODE, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PM_SOURCE_CODE PM_SOURCE_CODE, PM_SOURCE_REFERENCE PM_SOURCE_REFERENCE, WBS_RECORD_VERSION_NUMBER WBS_RECORD_VERSION_NUMBER, CHANGE_REASON_CODE CHANGE_REASON_CODE, PROCESS_UPDATE_WBS_FLAG PROCESS_UPDATE_WBS_FLAG, CONC_REQUEST_ID CONC_REQUEST_ID, PROCESS_CODE PROCESS_CODE, CURRENT_WORKING_FLAG CURRENT_WORKING_FLAG, SCHEDULE_DIRTY_FLAG SCHEDULE_DIRTY_FLAG, DATE_PROG_APPLIED_ON_WVER DATE_PROG_APPLIED_ON_WVER, SOURCE_OBJECT_ID SOURCE_OBJECT_ID, SOURCE_OBJECT_TYPE SOURCE_OBJECT_TYPE, PURGED_FLAG PURGED_FLAG from "PA"."PA_PROJ_ELEM_VER_STRUCTURE"

View Text - HTML Formatted

SELECT PEV_STRUCTURE_ID PEV_STRUCTURE_ID
, ELEMENT_VERSION_ID ELEMENT_VERSION_ID
, VERSION_NUMBER VERSION_NUMBER
, NAME NAME
, PROJECT_ID PROJECT_ID
, PROJ_ELEMENT_ID PROJ_ELEMENT_ID
, CURRENT_FLAG CURRENT_FLAG
, ORIGINAL_FLAG ORIGINAL_FLAG
, LATEST_EFF_PUBLISHED_FLAG LATEST_EFF_PUBLISHED_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, DESCRIPTION DESCRIPTION
, EFFECTIVE_DATE EFFECTIVE_DATE
, PUBLISHED_DATE PUBLISHED_DATE
, PUBLISHED_BY_PERSON_ID PUBLISHED_BY_PERSON_ID
, CURRENT_BASELINE_DATE CURRENT_BASELINE_DATE
, CURRENT_BASELINE_PERSON_ID CURRENT_BASELINE_PERSON_ID
, ORIGINAL_BASELINE_DATE ORIGINAL_BASELINE_DATE
, ORIGINAL_BASELINE_PERSON_ID ORIGINAL_BASELINE_PERSON_ID
, LOCK_STATUS_CODE LOCK_STATUS_CODE
, LOCKED_BY_PERSON_ID LOCKED_BY_PERSON_ID
, LOCKED_DATE LOCKED_DATE
, STATUS_CODE STATUS_CODE
, WF_STATUS_CODE WF_STATUS_CODE
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PM_SOURCE_CODE PM_SOURCE_CODE
, PM_SOURCE_REFERENCE PM_SOURCE_REFERENCE
, WBS_RECORD_VERSION_NUMBER WBS_RECORD_VERSION_NUMBER
, CHANGE_REASON_CODE CHANGE_REASON_CODE
, PROCESS_UPDATE_WBS_FLAG PROCESS_UPDATE_WBS_FLAG
, CONC_REQUEST_ID CONC_REQUEST_ID
, PROCESS_CODE PROCESS_CODE
, CURRENT_WORKING_FLAG CURRENT_WORKING_FLAG
, SCHEDULE_DIRTY_FLAG SCHEDULE_DIRTY_FLAG
, DATE_PROG_APPLIED_ON_WVER DATE_PROG_APPLIED_ON_WVER
, SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, SOURCE_OBJECT_TYPE SOURCE_OBJECT_TYPE
, PURGED_FLAG PURGED_FLAG
FROM "PA"."PA_PROJ_ELEM_VER_STRUCTURE"