View: PA_RBS_VERSIONS_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_V

View Text

SELECT VER.RBS_VERSION_ID
, VER.RBS_HEADER_ID
, VERTL.NAME
, VERTL.DESCRIPTION
, VER.VERSION_NUMBER
, VER.VERSION_START_DATE
, VER.VERSION_END_DATE
, VER.JOB_GROUP_ID
, VER.RULE_BASED_FLAG
, VER.CURRENT_REPORTING_FLAG
FROM PA_RBS_VERSIONS_B VER
, PA_RBS_VERSIONS_TL VERTL
WHERE VER.RBS_VERSION_ID = VERTL.RBS_VERSION_ID
AND VERTL.LANGUAGE = USERENV('LANG')
AND VER.STATUS_CODE = 'FROZEN'

Columns