VIEW: APPS.PA_RBS_ELEMENTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'