PER_NUDGE_PLAN_NDG_CHNLS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

PLAN_NUDGE_CHANNEL_ID PLAN_NUDGE_CHANNEL_CODE PLAN_NUDGE_ID TITLE CONTENT ACTION_LABEL CHANNEL_TYPE RECIPIENT_TYPE STATUS CONTENT_SOURCE HEADING_RESOURCE TITLE_RESOURCE CONTENT_RESOURCE ADDITIONAL_CONTENT1_RESOURCE ADDITIONAL_CONTENT2_RESOURCE ACTION_LABEL_RESOURCE TEMPLATE_ID CHECKLIST_ID INITIATOR_PERSON_ID DISMISS_FLAG DEFERRAL_TYPE DEFERRAL_DAYS ACTION_TYPE APPLICATION_TASK_CODE ACTION_CODE ACTION_URL REPORT_PATH REMINDER_FLAG REMINDER_RECURRENCE REMINDER_DURATION REMINDER_RELATIVE_TO REMINDER_OFFSET REASSIGN_ON_RECIPIENT_CHANGE PRIORITY GROUP_ID ENTERPRISE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.PLAN_NUDGE_CHANNEL_ID, B.PLAN_NUDGE_CHANNEL_CODE, B.PLAN_NUDGE_ID, TL.TITLE, TL.CONTENT, TL.ACTION_LABEL, B.CHANNEL_TYPE, B.RECIPIENT_TYPE, B.STATUS, B.CONTENT_SOURCE, B.HEADING_RESOURCE, B.TITLE_RESOURCE, B.CONTENT_RESOURCE, B.ADDITIONAL_CONTENT1_RESOURCE, B.ADDITIONAL_CONTENT2_RESOURCE, B.ACTION_LABEL_RESOURCE, B.TEMPLATE_ID, B.CHECKLIST_ID, B.INITIATOR_PERSON_ID, B.DISMISS_FLAG, B.DEFERRAL_TYPE, B.DEFERRAL_DAYS, B.ACTION_TYPE, B.APPLICATION_TASK_CODE, B.ACTION_CODE, B.ACTION_URL, B.REPORT_PATH, B.REMINDER_FLAG, B.REMINDER_RECURRENCE, B.REMINDER_DURATION, B.REMINDER_RELATIVE_TO, B.REMINDER_OFFSET, B.REASSIGN_ON_RECIPIENT_CHANGE, B.PRIORITY, B.GROUP_ID, B.ENTERPRISE_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM PER_NUDGE_PLAN_NDG_CHNLS_B B, PER_NUDGE_PLAN_NDG_CHNLS_TL TL WHERE B.PLAN_NUDGE_CHANNEL_ID = TL.PLAN_NUDGE_CHANNEL_ID AND TL.LANGUAGE = USERENV('LANG')