VIEW: APPS.CS_SR_SAVED_SEARCHES_VL

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID, A.SEARCH_ID, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY , A.CREATION_DATE , A.CREATED_BY , A.LAST_UPDATE_LOGIN , A.USER_ID, A.ATTRIBUTE1, A.ATTRIBUTE2 , A.ATTRIBUTE3 , A.ATTRIBUTE4, A.ATTRIBUTE5 , A.ATTRIBUTE6, A.ATTRIBUTE7, A.ATTRIBUTE8, A.ATTRIBUTE9, A.ATTRIBUTE10 , A.ATTRIBUTE11, A.ATTRIBUTE12, A.ATTRIBUTE13, A.ATTRIBUTE14, A.ATTRIBUTE15, A.CONTEXT, A.OBJECT_VERSION_NUMBER, A.SECURITY_GROUP_ID, B.NAME, B.LANGUAGE, B.SOURCE_LANG FROM CS_SR_SAVED_SEARCHES_B A, CS_SR_SAVED_SEARCHES_TL B WHERE A.SEARCH_ID = B.SEARCH_ID AND B.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.SEARCH_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.USER_ID
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.CONTEXT
, A.OBJECT_VERSION_NUMBER
, A.SECURITY_GROUP_ID
, B.NAME
, B.LANGUAGE
, B.SOURCE_LANG
FROM CS_SR_SAVED_SEARCHES_B A
, CS_SR_SAVED_SEARCHES_TL B
WHERE A.SEARCH_ID = B.SEARCH_ID
AND B.LANGUAGE = USERENV('LANG')