VIEW: APPS.PA_RBS_HEADERS_VL

Source

View Text - Preformatted

SELECT b.rowid row_id, b.rbs_header_id, b.effective_from_date, b.effective_to_date, b.business_group_id, b.use_for_alloc_flag, b.last_update_date, b.last_updated_by, b.creation_date, b.created_by, b.last_update_login , b.record_version_number, t.name, t.description, b.cbs_enabled, b.active_flag FROM PA_RBS_HEADERS_TL T, PA_RBS_HEADERS_B B WHERE B.rbs_header_id = T.rbs_header_id AND T.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RBS_HEADER_ID
, B.EFFECTIVE_FROM_DATE
, B.EFFECTIVE_TO_DATE
, B.BUSINESS_GROUP_ID
, B.USE_FOR_ALLOC_FLAG
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.RECORD_VERSION_NUMBER
, T.NAME
, T.DESCRIPTION
, B.CBS_ENABLED
, B.ACTIVE_FLAG
FROM PA_RBS_HEADERS_TL T
, PA_RBS_HEADERS_B B
WHERE B.RBS_HEADER_ID = T.RBS_HEADER_ID
AND T.LANGUAGE = USERENV('LANG')