[Home] [Help]
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
Name |
RBS_ELEMENT_ID |
RESOURCE_NAME |
RBS_VERSION_ID |
RESOURCE_TYPE_ID |
RESOURCE_SOURCE_ID |
RBS_LEVEL |
PARENT_ELEMENT_ID |
RULE_FLAG |