VIEW: APPS.MTL_ITEM_TEMPL_ATTRIBUTES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'