[Home] [Help]
View: FND_FLEX_HIERARCHIES_VL
View Text
SELECT B.ROWID ROW_ID
, B.FLEX_VALUE_SET_ID
, B.HIERARCHY_ID
, B.HIERARCHY_CODE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.HIERARCHY_NAME
, T.DESCRIPTION
FROM FND_FLEX_HIERARCHIES_TL T
, FND_FLEX_HIERARCHIES B
WHERE B.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID
AND B.HIERARCHY_ID = T.HIERARCHY_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
| Name |
| ROW_ID |
| FLEX_VALUE_SET_ID |
| HIERARCHY_ID |
| HIERARCHY_CODE |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| HIERARCHY_NAME |
| DESCRIPTION |
APPS.FND_FLEX_HIERARCHIES_VL