PER_NUDGE_PLAN_NUDGES_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

PLAN_NUDGE_ID NAME DESCRIPTION PLAN_NUDGE_CODE NUDGE_PLAN_ID PRODUCT_CODE NUDGE_TYPE_CODE STATUS INPUT_PARAMETER1 INPUT_PARAMETER2 INPUT_PARAMETER3 INPUT_PARAMETER4 INPUT_PARAMETER5 INPUT_PARAMETER6 INPUT_PARAMETER7 INPUT_PARAMETER8 INPUT_PARAMETER9 INPUT_PARAMETER10 INPUT_PARAMETER_NUMBER1 INPUT_PARAMETER_NUMBER2 INPUT_PARAMETER_NUMBER3 INPUT_PARAMETER_NUMBER4 INPUT_PARAMETER_NUMBER5 INPUT_PARAMETER_DATE1 INPUT_PARAMETER_DATE2 INPUT_PARAMETER_DATE3 INPUT_PARAMETER_DATE4 INPUT_PARAMETER_DATE5 EXPIRY_FLAG EXPIRY_DURATION EXPIRY_DURATION_UOM EXPIRY_RELATIVE_TO 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_ID, TL.NAME, TL.DESCRIPTION, B.PLAN_NUDGE_CODE, B.NUDGE_PLAN_ID, B.PRODUCT_CODE, B.NUDGE_TYPE_CODE, B.STATUS, B.INPUT_PARAMETER1, B.INPUT_PARAMETER2, B.INPUT_PARAMETER3, B.INPUT_PARAMETER4, B.INPUT_PARAMETER5, B.INPUT_PARAMETER6, B.INPUT_PARAMETER7, B.INPUT_PARAMETER8, B.INPUT_PARAMETER9, B.INPUT_PARAMETER10, B.INPUT_PARAMETER_NUMBER1, B.INPUT_PARAMETER_NUMBER2, B.INPUT_PARAMETER_NUMBER3, B.INPUT_PARAMETER_NUMBER4, B.INPUT_PARAMETER_NUMBER5, B.INPUT_PARAMETER_DATE1, B.INPUT_PARAMETER_DATE2, B.INPUT_PARAMETER_DATE3, B.INPUT_PARAMETER_DATE4, B.INPUT_PARAMETER_DATE5, B.EXPIRY_FLAG, B.EXPIRY_DURATION, B.EXPIRY_DURATION_UOM, B.EXPIRY_RELATIVE_TO, 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_NUDGES_B B, PER_NUDGE_PLAN_NUDGES_TL TL WHERE B.PLAN_NUDGE_ID = TL.PLAN_NUDGE_ID AND TL.LANGUAGE = USERENV('LANG')