|
SELECT
VALUE_SET_CODE1 VALUE_SET_CODE,
VALUE_SET_CODE2 RELATED_VALUE_SET_CODE,
ENABLED_FLAG ENABLED_FLAG,
CREATION_DATE CREATION_DATE,
CREATED_BY CREATED_BY,
LAST_UPDATE_DATE LAST_UPDATE_DATE,
LAST_UPDATED_BY LAST_UPDATED_BY
FROM FND_VS_RELATED_SETS
UNION ALL
SELECT
VALUE_SET_CODE2 VALUE_SET_CODE,
VALUE_SET_CODE1 RELATED_VALUE_SET_CODE,
ENABLED_FLAG ENABLED_FLAG,
CREATION_DATE CREATION_DATE,
CREATED_BY CREATED_BY,
LAST_UPDATE_DATE LAST_UPDATE_DATE,
LAST_UPDATED_BY LAST_UPDATED_BY
FROM FND_VS_RELATED_SETS
|