View: PA_RBS_ELEMENTS_V

Product:	PA - Projects
Description:	This view shows the element information and the parent-child relationship for all elements in a resource breakdown structure.
Implementation/DBA Data:	APPS.PA_RBS_ELEMENTS_V

View Text

SELECT ELE.RBS_ELEMENT_ID
, LPAD(' '
, ELE.RBS_LEVEL) || ENAME.RESOURCE_NAME
, ELE.RBS_VERSION_ID
, ELE.RESOURCE_TYPE_ID
, ELE.RESOURCE_SOURCE_ID
, ELE.RBS_LEVEL
, ELE.PARENT_ELEMENT_ID
, ELE.RULE_FLAG
FROM PA_RBS_ELEMENTS ELE
, PA_RBS_ELEMENT_NAMES_TL ENAME
WHERE ELE.RBS_ELEMENT_NAME_ID (+) = ENAME.RBS_ELEMENT_NAME_ID
AND ENAME.LANGUAGE = USERENV('LANG')
AND USER_CREATED_FLAG = 'N'

Columns