ENQ_AFFECTED_OBJECTS_VL

Details

• Schema: FUSION

• Object owner: ENQ

• Object type: VIEW

Columns

Name
AFFECTED_OBJECT_ID OBJECT_ID OBJECT_TYPE PK1_VALUE PK2_VALUE PK3_VALUE PK4_VALUE PK5_VALUE PK6_VALUE PK7_VALUE STATUS SUPPORTED_ENTITY_ID IMPACT_TYPE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESCRIPTION

Query

SQL_Statement

SELECT ENQ_AFFECTED_OBJECTS_B.AFFECTED_OBJECT_ID AFFECTED_OBJECT_ID, ENQ_AFFECTED_OBJECTS_B.OBJECT_ID OBJECT_ID, ENQ_AFFECTED_OBJECTS_B.OBJECT_TYPE OBJECT_TYPE, ENQ_AFFECTED_OBJECTS_B.PK1_VALUE PK1_VALUE, ENQ_AFFECTED_OBJECTS_B.PK2_VALUE PK2_VALUE, ENQ_AFFECTED_OBJECTS_B.PK3_VALUE PK3_VALUE, ENQ_AFFECTED_OBJECTS_B.PK4_VALUE PK4_VALUE, ENQ_AFFECTED_OBJECTS_B.PK5_VALUE PK5_VALUE, ENQ_AFFECTED_OBJECTS_B.PK6_VALUE PK6_VALUE, ENQ_AFFECTED_OBJECTS_B.PK7_VALUE PK7_VALUE, ENQ_AFFECTED_OBJECTS_B.STATUS STATUS, ENQ_AFFECTED_OBJECTS_B.SUPPORTED_ENTITY_ID SUPPORTED_ENTITY_ID, ENQ_AFFECTED_OBJECTS_B.IMPACT_TYPE IMPACT_TYPE, ENQ_AFFECTED_OBJECTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ENQ_AFFECTED_OBJECTS_B.CREATED_BY CREATED_BY, ENQ_AFFECTED_OBJECTS_B.CREATION_DATE CREATION_DATE, ENQ_AFFECTED_OBJECTS_B.LAST_UPDATED_BY LAST_UPDATED_BY, ENQ_AFFECTED_OBJECTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ENQ_AFFECTED_OBJECTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ENQ_AFFECTED_OBJECTS_TL.DESCRIPTION DESCRIPTION FROM ENQ_AFFECTED_OBJECTS_B, ENQ_AFFECTED_OBJECTS_TL WHERE ENQ_AFFECTED_OBJECTS_B.AFFECTED_OBJECT_ID = ENQ_AFFECTED_OBJECTS_TL.AFFECTED_OBJECT_ID AND ENQ_AFFECTED_OBJECTS_TL.LANGUAGE = USERENV('LANG')