SELECT OBJECTS.Object_Name, EAV_OBJECTS.OBJECT_ID, EAV_OBJECTS.ATTRIBUTE_ID, NVL(EAV_OBJECTS.VALUE_, 0) AS VALUE_, EAV_OBJECTS.SERIAL_NO
FROM OBJECTS, ATTRIBUTES, EAV_OBJECTS
WHERE ATTRIBUTES.Class_ID=20
AND ATTRIBUTES.Datatype='H'
AND ATTRIBUTES.Attribute_ID = EAV_OBJECTS.Attribute_ID
AND OBJECTS.Object_ID = EAV_OBJECTS.object_id
ORDER BY NVL(EAV_OBJECTS.VALUE_, 0), EAV_OBJECTS.Serial_No
|