View: MTL_ITEM_TEMPL_ATTRIBUTES_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_ITEM_TEMPL_ATTRIBUTES_V

View Text

SELECT TA.ROWID ROW_ID
, TA.TEMPLATE_ID
, ATT.USER_ATTRIBUTE_NAME_GUI
, TA.ATTRIBUTE_NAME
, TA.ATTRIBUTE_VALUE
, TA.ENABLED_FLAG
, ATT.CONTROL_LEVEL
, MFG.MEANING
, ATT.ATTRIBUTE_GROUP_ID_GUI
, ATT.SEQUENCE_GUI
, TA.REPORT_USER_VALUE
, ATT.MANDATORY_FLAG
, ATT.VALIDATION_CODE
, ATT.DATA_TYPE
, TA.LAST_UPDATE_DATE
, TA.LAST_UPDATED_BY
, TA.CREATION_DATE
, TA.CREATED_BY
, TA.LAST_UPDATE_LOGIN
, IT.GLOBAL_ATTRIBUTE_CATEGORY
, IT.GLOBAL_ATTRIBUTE1
, IT.GLOBAL_ATTRIBUTE2
, IT.GLOBAL_ATTRIBUTE3
, IT.GLOBAL_ATTRIBUTE4
, IT.GLOBAL_ATTRIBUTE5
, IT.GLOBAL_ATTRIBUTE6
, IT.GLOBAL_ATTRIBUTE7
, IT.GLOBAL_ATTRIBUTE8
, IT.GLOBAL_ATTRIBUTE9
, IT.GLOBAL_ATTRIBUTE10
, IT.GLOBAL_ATTRIBUTE11
, IT.GLOBAL_ATTRIBUTE12
, IT.GLOBAL_ATTRIBUTE13
, IT.GLOBAL_ATTRIBUTE14
, IT.GLOBAL_ATTRIBUTE15
, IT.GLOBAL_ATTRIBUTE16
, IT.GLOBAL_ATTRIBUTE17
, IT.GLOBAL_ATTRIBUTE18
, IT.GLOBAL_ATTRIBUTE19
, IT.GLOBAL_ATTRIBUTE20
FROM MTL_ITEM_TEMPL_ATTRIBUTES TA
, MTL_ITEM_ATTRIBUTES ATT
, MTL_ITEM_TEMPLATES IT
, MFG_LOOKUPS MFG
WHERE ATT.ATTRIBUTE_NAME (+) = TA.ATTRIBUTE_NAME
AND IT.TEMPLATE_ID (+) = TA.TEMPLATE_ID
AND MFG.LOOKUP_CODE (+) = ATT.CONTROL_LEVEL
AND MFG.LOOKUP_TYPE (+) = 'ITEM_CONTROL_LEVEL_GUI'

Columns