FND_PILLAR_INSTANCE_VL

Details

• Schema: TAXONOMY

• Object type: VIEW

Columns

Name
PILLAR_INSTANCE_NAME PILLAR_TOPOLOGY_OPTION_NAME LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ENTERPRISE_ID DESCRIPTION

Query

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')