FND_VS_RELATED_VALUES_V

Details

  • Schema: VST

  • Object owner: FND

  • Object type: VIEW

Columns

Name

VALUE_SET_CODE

VALUE_ID

RELATED_VALUE_SET_CODE

RELATED_VALUE_ID

ENABLED_FLAG

Query

SQL_Statement

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