FND_PILLAR_INSTANCE_VL
詳細
-
スキーマ: TAXONOMY
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PILLAR_INSTANCE_NAME PILLAR_TOPOLOGY_OPTION_NAME LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ENTERPRISE_ID DESCRIPTION |
問合せ
| SQL_Statement |
|---|
|
SELECT B.PILLAR_INSTANCE_NAME PILLAR_INSTANCE_NAME, B.PILLAR_TOPOLOGY_OPTION_NAME PILLAR_TOPOLOGY_OPTION_NAME, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.ENTERPRISE_ID ENTERPRISE_ID, T.DESCRIPTION DESCRIPTION FROM FND_PILLAR_INSTANCE_B B, FND_PILLAR_INSTANCE_TL T WHERE B.PILLAR_INSTANCE_NAME = T.PILLAR_INSTANCE_NAME AND B.PILLAR_TOPOLOGY_OPTION_NAME = T.PILLAR_TOPOLOGY_OPTION_NAME AND T.LANGUAGE = USERENV('LANG') |