VIEW: APPS.MTL_ITEM_TEMPLATES_VL

Source

View Text - Preformatted

SELECT BASE.ROWID ,BASE.TEMPLATE_ID ,TL.TEMPLATE_NAME ,TL.DESCRIPTION ,BASE. LAST_UPDATE_DATE ,BASE.LAST_UPDATED_BY ,BASE.CREATION_DATE ,BASE.CREATED_BY ,BASE.LAST_UPDATE_LOGIN ,BASE.ATTRIBUTE_CATEGORY ,BASE.ATTRIBUTE1 ,BASE.ATTRIBUTE2 ,BASE.ATTRIBUTE3 ,BASE.ATTRIBUTE4 ,BASE.ATTRIBUTE5 ,BASE.ATTRIBUTE6 ,BASE.ATTRIBUTE7 ,BASE.ATTRIBUTE8 ,BASE.ATTRIBUTE9 ,BASE.ATTRIBUTE10 ,BASE.ATTRIBUTE11 ,BASE.ATTRIBUTE12 ,BASE.ATTRIBUTE13 ,BASE.ATTRIBUTE14 ,BASE.ATTRIBUTE15 ,BASE.REQUEST_ID ,BASE.PROGRAM_APPLICATION_ID ,BASE.PROGRAM_ID ,BASE.PROGRAM_UPDATE_DATE ,BASE.CONTEXT_ORGANIZATION_ID ,BASE.GLOBAL_ATTRIBUTE_CATEGORY ,BASE.GLOBAL_ATTRIBUTE1 ,BASE.GLOBAL_ATTRIBUTE2 ,BASE.GLOBAL_ATTRIBUTE3 ,BASE.GLOBAL_ATTRIBUTE4 ,BASE.GLOBAL_ATTRIBUTE5 ,BASE.GLOBAL_ATTRIBUTE6 ,BASE.GLOBAL_ATTRIBUTE7 ,BASE.GLOBAL_ATTRIBUTE8 ,BASE.GLOBAL_ATTRIBUTE9 ,BASE.GLOBAL_ATTRIBUTE10 ,BASE.GLOBAL_ATTRIBUTE11 ,BASE.GLOBAL_ATTRIBUTE12 ,BASE.GLOBAL_ATTRIBUTE13 ,BASE.GLOBAL_ATTRIBUTE14 ,BASE.GLOBAL_ATTRIBUTE15 ,BASE.GLOBAL_ATTRIBUTE16 ,BASE.GLOBAL_ATTRIBUTE17 ,BASE.GLOBAL_ATTRIBUTE18 ,BASE.GLOBAL_ATTRIBUTE19 ,BASE.GLOBAL_ATTRIBUTE20 FROM MTL_ITEM_TEMPLATES_B BASE, MTL_ITEM_TEMPLATES_TL TL WHERE BASE.TEMPLATE_ID = TL.TEMPLATE_ID AND TL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT BASE.ROWID
, BASE.TEMPLATE_ID
, TL.TEMPLATE_NAME
, TL.DESCRIPTION
, BASE. LAST_UPDATE_DATE
, BASE.LAST_UPDATED_BY
, BASE.CREATION_DATE
, BASE.CREATED_BY
, BASE.LAST_UPDATE_LOGIN
, BASE.ATTRIBUTE_CATEGORY
, BASE.ATTRIBUTE1
, BASE.ATTRIBUTE2
, BASE.ATTRIBUTE3
, BASE.ATTRIBUTE4
, BASE.ATTRIBUTE5
, BASE.ATTRIBUTE6
, BASE.ATTRIBUTE7
, BASE.ATTRIBUTE8
, BASE.ATTRIBUTE9
, BASE.ATTRIBUTE10
, BASE.ATTRIBUTE11
, BASE.ATTRIBUTE12
, BASE.ATTRIBUTE13
, BASE.ATTRIBUTE14
, BASE.ATTRIBUTE15
, BASE.REQUEST_ID
, BASE.PROGRAM_APPLICATION_ID
, BASE.PROGRAM_ID
, BASE.PROGRAM_UPDATE_DATE
, BASE.CONTEXT_ORGANIZATION_ID
, BASE.GLOBAL_ATTRIBUTE_CATEGORY
, BASE.GLOBAL_ATTRIBUTE1
, BASE.GLOBAL_ATTRIBUTE2
, BASE.GLOBAL_ATTRIBUTE3
, BASE.GLOBAL_ATTRIBUTE4
, BASE.GLOBAL_ATTRIBUTE5
, BASE.GLOBAL_ATTRIBUTE6
, BASE.GLOBAL_ATTRIBUTE7
, BASE.GLOBAL_ATTRIBUTE8
, BASE.GLOBAL_ATTRIBUTE9
, BASE.GLOBAL_ATTRIBUTE10
, BASE.GLOBAL_ATTRIBUTE11
, BASE.GLOBAL_ATTRIBUTE12
, BASE.GLOBAL_ATTRIBUTE13
, BASE.GLOBAL_ATTRIBUTE14
, BASE.GLOBAL_ATTRIBUTE15
, BASE.GLOBAL_ATTRIBUTE16
, BASE.GLOBAL_ATTRIBUTE17
, BASE.GLOBAL_ATTRIBUTE18
, BASE.GLOBAL_ATTRIBUTE19
, BASE.GLOBAL_ATTRIBUTE20
FROM MTL_ITEM_TEMPLATES_B BASE
, MTL_ITEM_TEMPLATES_TL TL
WHERE BASE.TEMPLATE_ID = TL.TEMPLATE_ID
AND TL.LANGUAGE = USERENV('LANG')