View: SO_STANDARD_VALUE_SOURCES

Product:	OE - Order Entry
Description:	Stores seeded standard value rules sources
Implementation/DBA Data:	APPS.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