VIEW: APPS.CS_SR_TYPE_CATEGORIES_VL

Source

View Text - Preformatted

SELECT A.SR_TYPE_CATEGORY_ID, A.DISPLAY_ORDER, A.IMAGE_FILE_NAME, A.START_DATE, A.END_DATE, A.OBJECT_VERSION_NUMBER, 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.ATTRIBUTE_CATEGORY, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_LOGIN, B.NAME, B.DESCRIPTION, B.LANGUAGE, B.SOURCE_LANG FROM CS_SR_TYPE_CATEGORIES_B A, CS_SR_TYPE_CATEGORIES_TL B WHERE A.SR_TYPE_CATEGORY_ID = B.SR_TYPE_CATEGORY_ID AND B.LANGUAGE = userenv ('LANG')

View Text - HTML Formatted

SELECT A.SR_TYPE_CATEGORY_ID
, A.DISPLAY_ORDER
, A.IMAGE_FILE_NAME
, A.START_DATE
, A.END_DATE
, A.OBJECT_VERSION_NUMBER
, 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.ATTRIBUTE_CATEGORY
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, B.NAME
, B.DESCRIPTION
, B.LANGUAGE
, B.SOURCE_LANG
FROM CS_SR_TYPE_CATEGORIES_B A
, CS_SR_TYPE_CATEGORIES_TL B
WHERE A.SR_TYPE_CATEGORY_ID = B.SR_TYPE_CATEGORY_ID
AND B.LANGUAGE = USERENV ('LANG')