[Home] [Help]
View: SO_STANDARD_VALUE_SOURCES
View Text
SELECT SOATR.ATTRIBUTE_ID
, SOATR.ATTRIBUTE_CODE
, SOATR.NAME
, SOATR.DESCRIPTION
, SOATR.REPRESENTED_OBJECT_ID
, SOOBJ.OBJECT_ID
, SOOBJ.OBJECT_CODE
, SOOBJ.NAME
, SOOBJ.DESCRIPTION
FROM SO_OBJECTS SOOBJ
, SO_ATTRIBUTES SOATR
, SO_ATTRIBUTE_USES SOUSE
WHERE SOATR.OBJECT_ID = SOOBJ.OBJECT_ID
AND SOUSE.ATTRIBUTE_ID = SOATR.ATTRIBUTE_ID
AND SOUSE.ATTRIBUTE_USE_CODE = 'STANDARD VALUE SOURCE' UNION SELECT GENERAL_STD_VALUE_SOURCE_ID
, NULL
, NULL
, NULL
, -1
, -1
, NULL
, NAME
, DESCRIPTION
FROM SO_GENERAL_STD_VALUE_SOURCES
Columns
Name |
STANDARD_VALUE_SOURCE_ID |
ATTRIBUTE_CODE |
ATTRIBUTE_NAME |
ATTRIBUTE_DESCRIPTION |
REPRESENTED_OBJECT_ID |
OBJECT_ID |
OBJECT_CODE |
OBJECT_NAME |
OBJECT_DESCRIPTION |