DBA Data[Home] [Help]

VIEW: APPS.PA_RBS_ELEMENT_NAMES_VL

Source

View Text - Preformatted

SELECT b.rowid row_id, b.rbs_element_name_id, b.resource_source_id, b.resource_type_id, b.last_update_date, b.last_updated_by, b.creation_date, b.created_by, b.last_update_login, t.resource_name from PA_RBS_ELEMENT_NAMES_TL T, PA_RBS_ELEMENT_NAMES_B B WHERE B.rbs_element_name_id = T.rbs_element_name_id and T.language = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RBS_ELEMENT_NAME_ID
, B.RESOURCE_SOURCE_ID
, B.RESOURCE_TYPE_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.RESOURCE_NAME
FROM PA_RBS_ELEMENT_NAMES_TL T
, PA_RBS_ELEMENT_NAMES_B B
WHERE B.RBS_ELEMENT_NAME_ID = T.RBS_ELEMENT_NAME_ID
AND T.LANGUAGE = USERENV('LANG')