HRC_ARM_NOTIFICATIONS_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
NOTIFICATION_ID PROCESS_ID TASK_STATUS RECIPIENT_TYPE USER_NAME ENABLED DELIVERY_MODE ENTERPRISE_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NOTIFICATION_HEADER NOTIFICATION_CONTENT

Query

SQL_Statement

SELECT HAN.NOTIFICATION_ID NOTIFICATION_ID, HAN.PROCESS_ID PROCESS_ID, HAN.TASK_STATUS TASK_STATUS, HAN.RECIPIENT_TYPE RECIPIENT_TYPE, HAN.USER_NAME USER_NAME, HAN.ENABLED ENABLED, HAN.DELIVERY_MODE DELIVERY_MODE, HAN.ENTERPRISE_ID ENTERPRISE_ID, HAN.MODULE_ID MODULE_ID, HAN.CREATED_BY CREATED_BY, HAN.CREATION_DATE CREATION_DATE, HAN.LAST_UPDATED_BY LAST_UPDATED_BY, HAN.LAST_UPDATE_DATE LAST_UPDATE_DATE, HAN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HAN.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HANTL.NOTIFICATION_HEADER NOTIFICATION_HEADER, HANTL.NOTIFICATION_CONTENT NOTIFICATION_CONTENT FROM HRC_ARM_NOTIFICATIONS_B HAN, HRC_ARM_NOTIFICATIONS_TL HANTL WHERE HAN.NOTIFICATION_ID = HANTL.NOTIFICATION_ID AND HANTL.LANGUAGE = USERENV('LANG')