[Home] [Help] [Dependency Information]
Object Name: | PA_PROJ_ELEM_VER_STRUCTURE# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PEV_STRUCTURE_ID | NUMBER | (15) | Yes | |
ELEMENT_VERSION_ID | NUMBER | (15) | Yes | |
VERSION_NUMBER | NUMBER | Yes | ||
NAME | VARCHAR2 | (240) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
PROJ_ELEMENT_ID | NUMBER | (15) | Yes | |
CURRENT_FLAG | VARCHAR2 | (1) | Yes | |
ORIGINAL_FLAG | VARCHAR2 | (1) | Yes | |
LATEST_EFF_PUBLISHED_FLAG | VARCHAR2 | (1) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
DESCRIPTION | VARCHAR2 | (2000) | ||
EFFECTIVE_DATE | DATE | |||
PUBLISHED_DATE | DATE | |||
PUBLISHED_BY_PERSON_ID | NUMBER | (15) | ||
CURRENT_BASELINE_DATE | DATE | |||
CURRENT_BASELINE_PERSON_ID | NUMBER | (15) | ||
ORIGINAL_BASELINE_DATE | DATE | |||
ORIGINAL_BASELINE_PERSON_ID | NUMBER | (15) | ||
LOCK_STATUS_CODE | VARCHAR2 | (30) | ||
LOCKED_BY_PERSON_ID | NUMBER | (15) | ||
LOCKED_DATE | DATE | |||
STATUS_CODE | VARCHAR2 | (150) | ||
WF_STATUS_CODE | VARCHAR2 | (30) | ||
RECORD_VERSION_NUMBER | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PM_SOURCE_CODE | VARCHAR2 | (30) | ||
PM_SOURCE_REFERENCE | VARCHAR2 | (25) | ||
WBS_RECORD_VERSION_NUMBER | NUMBER | (15) | ||
CHANGE_REASON_CODE | VARCHAR2 | (30) | ||
PROCESS_UPDATE_WBS_FLAG | VARCHAR2 | (1) | ||
CONC_REQUEST_ID | NUMBER | (15) | ||
PROCESS_CODE | VARCHAR2 | (30) | ||
CURRENT_WORKING_FLAG | VARCHAR2 | (1) | ||
SCHEDULE_DIRTY_FLAG | VARCHAR2 | (1) | ||
DATE_PROG_APPLIED_ON_WVER | DATE | |||
SOURCE_OBJECT_ID | NUMBER | (15) | ||
SOURCE_OBJECT_TYPE | VARCHAR2 | (30) | ||
PURGED_FLAG | VARCHAR2 | (2) |
Cut, paste (and edit) the following text to query this object:
SELECT PEV_STRUCTURE_ID
, ELEMENT_VERSION_ID
, VERSION_NUMBER
, NAME
, PROJECT_ID
, PROJ_ELEMENT_ID
, CURRENT_FLAG
, ORIGINAL_FLAG
, LATEST_EFF_PUBLISHED_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, DESCRIPTION
, EFFECTIVE_DATE
, PUBLISHED_DATE
, PUBLISHED_BY_PERSON_ID
, CURRENT_BASELINE_DATE
, CURRENT_BASELINE_PERSON_ID
, ORIGINAL_BASELINE_DATE
, ORIGINAL_BASELINE_PERSON_ID
, LOCK_STATUS_CODE
, LOCKED_BY_PERSON_ID
, LOCKED_DATE
, STATUS_CODE
, WF_STATUS_CODE
, RECORD_VERSION_NUMBER
, LAST_UPDATE_LOGIN
, PM_SOURCE_CODE
, PM_SOURCE_REFERENCE
, WBS_RECORD_VERSION_NUMBER
, CHANGE_REASON_CODE
, PROCESS_UPDATE_WBS_FLAG
, CONC_REQUEST_ID
, PROCESS_CODE
, CURRENT_WORKING_FLAG
, SCHEDULE_DIRTY_FLAG
, DATE_PROG_APPLIED_ON_WVER
, SOURCE_OBJECT_ID
, SOURCE_OBJECT_TYPE
, PURGED_FLAG
FROM PA.PA_PROJ_ELEM_VER_STRUCTURE#;
|
|
|