PER_NUDGE_PLANS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
NUDGE_PLAN_ID NAME DESCRIPTION NUDGE_PLAN_CODE STATUS START_DATE END_DATE CRITERIA_CONDITION1 CRITERIA_CONDITION2 CRITERIA_CONDITION3 CRITERIA_CONDITION4 CRITERIA_CONDITION5 CRITERIA_TYPE LIST_ID ENABLE_SCHEDULE ENTERPRISE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.NUDGE_PLAN_ID, TL.NAME, TL.DESCRIPTION, B.NUDGE_PLAN_CODE, B.STATUS, B.START_DATE, B.END_DATE, B.CRITERIA_CONDITION1, B.CRITERIA_CONDITION2, B.CRITERIA_CONDITION3, B.CRITERIA_CONDITION4, B.CRITERIA_CONDITION5, B.CRITERIA_TYPE, B.LIST_ID, B.ENABLE_SCHEDULE, 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_PLANS_B B, PER_NUDGE_PLANS_TL TL WHERE B.NUDGE_PLAN_ID = TL.NUDGE_PLAN_ID AND TL.LANGUAGE = USERENV('LANG')