View: PA_RBS_ELEMENTS_AMG_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_AMG_V

View Text

SELECT RH.RBS_HEADER_ID
, RH.NAME
, ELE.RBS_VERSION_ID
, RV.NAME
, RV.VERSION_NUMBER
, ELE.RBS_ELEMENT_ID
, ENAME.RESOURCE_NAME
, ELE.RESOURCE_SOURCE_ID
, ELE.RESOURCE_TYPE_ID
, TYP.NAME
, ELE.RBS_LEVEL
, ELE.PARENT_ELEMENT_ID
, ELE.RULE_FLAG
FROM PA_RBS_VERSIONS_VL RV
, PA_RBS_HEADERS_VL RH
, PA_RBS_ELEMENTS ELE
, PA_RBS_ELEMENT_NAMES_VL ENAME
, PA_RES_TYPES_VL TYP
WHERE RH.RBS_HEADER_ID = RV.RBS_HEADER_ID
AND RV.RBS_VERSION_ID = ELE.RBS_VERSION_ID
AND ELE.RBS_ELEMENT_NAME_ID = ENAME.RBS_ELEMENT_NAME_ID
AND ELE.RESOURCE_TYPE_ID = TYP.RES_TYPE_ID (+)

Columns