[Home] [Help]
View: PA_STRUCTURE_VERSION_NAMES_V
Product: | PA - Projects |
Description: | PA_STRUCTURE_VERSION_NAMES_V selects structure version name and structure number. - For future use |
Implementation/DBA Data: |
APPS.PA_STRUCTURE_VERSION_NAMES_V
|
View Text
SELECT PEVS.NAME
, PEVS.VERSION_NUMBER
, PEVS.ELEMENT_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.NAME
, PPE.PROJECT_ID
, PEVS.PUBLISHED_DATE
, PEVS.STATUS_CODE
FROM PA_PROJ_ELEM_VER_STRUCTURE PEVS
, PA_PROJ_ELEMENTS PPE
WHERE PEVS.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PEVS.PROJECT_ID = PPE.PROJECT_ID
AND PEVS.PROJECT_ID <> 0
Columns
Name |
STRUCTURE_VERSION_NAME |
STRUCTURE_VERSION_NUMBER |
ELEMENT_VERSION_ID |
PROJ_ELEMENT_ID |
STRUCTURE_NAME |
PROJECT_ID |
PUBLISHED_DATE |
STATUS_CODE |