View: PA_RBS_VERSIONS_AMG_V

Product:	PA - Projects
Description:	This view shows the version information, such as dates and job group, for a resource breakdown structure version.
Implementation/DBA Data:	APPS.PA_RBS_VERSIONS_AMG_V

View Text

SELECT RH.RBS_HEADER_ID
, RH.NAME
, RV.RBS_VERSION_ID
, RV.NAME
, RV.VERSION_NUMBER
, RV.CURRENT_REPORTING_FLAG
, RV.STATUS_CODE
, RV.VERSION_START_DATE
, RV.VERSION_END_DATE
, RV.JOB_GROUP_ID
, JG.DISPLAYED_NAME
FROM PA_RBS_VERSIONS_VL RV
, PA_RBS_HEADERS_VL RH
, PER_JOB_GROUPS JG
WHERE RV.RBS_HEADER_ID = RH.RBS_HEADER_ID
AND RV.JOB_GROUP_ID = JG.JOB_GROUP_ID (+)

Columns