Product: | INV - Inventory |
---|---|
Description: | This table contains the columns of MTL_ITEM_TEMPLATES_B and MTL_ITEM_TEMPLATES_TL for current user's language settings |
Implementation/DBA Data: | APPS.MTL_ITEM_TEMPLATES_VL |
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')