VIEW: APPS.SO_STANDARD_VALUE_SOURCES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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