VIEW: APPS.HR_FORM_TEMPLATES_VL

Source

View Text - Preformatted

SELECT B.ROWID ,B.FORM_TEMPLATE_ID ,B.OBJECT_VERSION_NUMBER ,B.APPLICATION_ID ,B.FORM_ID ,B.TEMPLATE_NAME ,T.USER_TEMPLATE_NAME ,B.ENABLED_FLAG ,B.LEGISLATION_CODE ,T.DESCRIPTION ,B.ATTRIBUTE_CATEGORY ,B.ATTRIBUTE1 ,B.ATTRIBUTE2 ,B.ATTRIBUTE3 ,B.ATTRIBUTE4 ,B.ATTRIBUTE5 ,B.ATTRIBUTE6 ,B.ATTRIBUTE7 ,B.ATTRIBUTE8 ,B.ATTRIBUTE9 ,B.ATTRIBUTE10 ,B.ATTRIBUTE11 ,B.ATTRIBUTE12 ,B.ATTRIBUTE13 ,B.ATTRIBUTE14 ,B.ATTRIBUTE15 ,B.ATTRIBUTE16 ,B.ATTRIBUTE17 ,B.ATTRIBUTE18 ,B.ATTRIBUTE19 ,B.ATTRIBUTE20 ,B.ATTRIBUTE21 ,B.ATTRIBUTE22 ,B.ATTRIBUTE23 ,B.ATTRIBUTE24 ,B.ATTRIBUTE25 ,B.ATTRIBUTE26 ,B.ATTRIBUTE27 ,B.ATTRIBUTE28 ,B.ATTRIBUTE29 ,B.ATTRIBUTE30 ,B.LAST_UPDATE_DATE ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_LOGIN ,B.CREATED_BY ,B.CREATION_DATE FROM HR_FORM_TEMPLATES_B B ,HR_FORM_TEMPLATES_TL T WHERE B.FORM_TEMPLATE_ID = T.FORM_TEMPLATE_ID AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID
, B.FORM_TEMPLATE_ID
, B.OBJECT_VERSION_NUMBER
, B.APPLICATION_ID
, B.FORM_ID
, B.TEMPLATE_NAME
, T.USER_TEMPLATE_NAME
, B.ENABLED_FLAG
, B.LEGISLATION_CODE
, T.DESCRIPTION
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE16
, B.ATTRIBUTE17
, B.ATTRIBUTE18
, B.ATTRIBUTE19
, B.ATTRIBUTE20
, B.ATTRIBUTE21
, B.ATTRIBUTE22
, B.ATTRIBUTE23
, B.ATTRIBUTE24
, B.ATTRIBUTE25
, B.ATTRIBUTE26
, B.ATTRIBUTE27
, B.ATTRIBUTE28
, B.ATTRIBUTE29
, B.ATTRIBUTE30
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
FROM HR_FORM_TEMPLATES_B B
, HR_FORM_TEMPLATES_TL T
WHERE B.FORM_TEMPLATE_ID = T.FORM_TEMPLATE_ID
AND T.LANGUAGE = USERENV('LANG')