VIEW: APPS.MTL_ITEM_ATTRIBUTES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'