View: MTL_ITEM_ATTRIBUTES_V

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

View Text

SELECT MIA.ROWID ROW_ID
, ATTRIBUTE_NAME
, USER_ATTRIBUTE_NAME
, USER_ATTRIBUTE_NAME_GUI
, ATTRIBUTE_GROUP_ID
, ATTRIBUTE_GROUP_ID_GUI
, CONTROL_LEVEL
, DATA_TYPE
, SEQUENCE
, SEQUENCE_GUI
, LEVEL_UPDATEABLE_FLAG
, STATUS_CONTROL_CODE
, MIA.LAST_UPDATE_DATE
, MIA.LAST_UPDATED_BY
, MIA.CREATION_DATE
, MIA.CREATED_BY
, MIA.LAST_UPDATE_LOGIN
, VALIDATION_CODE
, PREFIELD_FLAG
, POST_CHANGE_FLAG
, POST_FIELD_FLAG
, MANDATORY_FLAG
, UPDATE_MESSAGE_NAME
, REQUIRED_MESSAGE_NAME
, ML1.LOOKUP_TYPE LOOKUP_TYPE1
, ML1.LOOKUP_CODE LOOKUP_CODE1
, ML1.MEANING MEANING1
, ML1.ENABLED_FLAG ENABLED_FLAG1
, ML2.LOOKUP_TYPE LOOKUP_TYPE2
, ML2.LOOKUP_CODE LOOKUP_CODE2
, ML2.MEANING MEANING2
, ML2.ENABLED_FLAG ENABLED_FLAG2
, ML3.LOOKUP_TYPE LOOKUP_TYPE3
, ML3.LOOKUP_CODE LOOKUP_CODE3
, ML3.MEANING MEANING3
, ML3.ENABLED_FLAG ENABLED_FLAG3
, ML4.LOOKUP_TYPE LOOKUP_TYPE4
, ML4.LOOKUP_CODE LOOKUP_CODE4
, ML4.MEANING MEANING4
, ML4.ENABLED_FLAG ENABLED_FLAG4
FROM MTL_ITEM_ATTRIBUTES MIA
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
WHERE ML1.LOOKUP_CODE = NVL(MIA.ATTRIBUTE_GROUP_ID_GUI
, ML1.LOOKUP_CODE)
AND ML1.LOOKUP_TYPE = 'ITEM_CHOICES_GUI'
AND ML2.LOOKUP_CODE = NVL(MIA.CONTROL_LEVEL
, -999)
AND ML2.LOOKUP_TYPE = 'ITEM_CONTROL_LEVEL'
AND ML3.LOOKUP_CODE(+) = NVL(MIA.STATUS_CONTROL_CODE
, -999)
AND ML3.LOOKUP_TYPE(+) = 'ITEM_STATUS_CONTROL'
AND ML4.LOOKUP_CODE(+) = NVL(MIA.VALIDATION_CODE
, -999)
AND ML4.LOOKUP_TYPE(+) = 'ITEM_ATTRIBUTE_VALIDATION'

Columns