|
SELECT
VALUE_SET_CODE1 VALUE_SET_CODE,
VALUE_ID1 VALUE_ID,
VALUE_SET_CODE2 RELATED_VALUE_SET_CODE,
VALUE_ID2 RELATED_VALUE_ID,
ENABLED_FLAG
FROM FND_VS_RELATED_VALUES
UNION ALL
SELECT
VALUE_SET_CODE2 VALUE_SET_CODE,
VALUE_ID2 VALUE_ID,
VALUE_SET_CODE1 RELATED_VALUE_SET_CODE,
VALUE_ID1 RELATED_VALUE_ID,
ENABLED_FLAG
FROM FND_VS_RELATED_VALUES
|