[Home] [Help]
View: PA_STRUCT_VERSIONS_LOV_AMG_V
View Text
SELECT PEVS.NAME
, PEVS.VERSION_NUMBER
, PEVS.ELEMENT_VERSION_ID
, LKP.MEANING
, PEVS.PROJ_ELEMENT_ID
, PEVS.PROJECT_ID
, PEVS.STATUS_CODE
, ST.STRUCTURE_TYPE_CLASS_CODE
FROM PA_PROJ_ELEM_VER_STRUCTURE PEVS
, PA_PROJ_STRUCTURE_TYPES PST
, PA_STRUCTURE_TYPES ST
, PA_LOOKUPS LKP
WHERE LKP.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS'
AND LKP.LOOKUP_CODE = ST.STRUCTURE_TYPE_CLASS_CODE
AND ST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PST.PROJ_ELEMENT_ID = PEVS.PROJ_ELEMENT_ID
Columns
Name |
STRUCTURE_VERSION_NAME |
STRUCTURE_VERSION_NUMBER |
STRUCTURE_VERSION_ID |
STRUCTURE_TYPE |
STRUCTURE_ID |
PROJECT_ID |
STATUS_CODE |
STRUCTURE_TYPE_CLASS_CODE |