PAY_EVENT_ACTIONS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

EVENT_ACTION_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE EVENT_ACTION_TYPE_ID BASE_NAME REPORT_TYPE ACTION_SUBMISSION ENTERPRISE_ID LOOKBACK_TIME_DEF_ID INFORMATION_CHAR1 INFORMATION_CHAR2 INFORMATION_CHAR3 INFORMATION_CHAR4 INFORMATION_CHAR5 INFORMATION_CHAR6 INFORMATION_CHAR7 INFORMATION_CHAR8 INFORMATION_CHAR9 INFORMATION_CHAR10 INFORMATION_CHAR11 INFORMATION_CHAR12 INFORMATION_CHAR13 INFORMATION_CHAR14 INFORMATION_CHAR15 INFORMATION_CHAR16 INFORMATION_CHAR17 INFORMATION_CHAR18 INFORMATION_CHAR19 INFORMATION_CHAR20 INFORMATION_CHAR21 INFORMATION_CHAR22 INFORMATION_CHAR23 INFORMATION_CHAR24 INFORMATION_CHAR25 INFORMATION_CHAR26 INFORMATION_CHAR27 INFORMATION_CHAR28 INFORMATION_CHAR29 INFORMATION_CHAR30 INFORMATION_NUMBER1 INFORMATION_NUMBER2 INFORMATION_NUMBER3 INFORMATION_NUMBER4 INFORMATION_NUMBER5 INFORMATION_NUMBER6 INFORMATION_NUMBER7 INFORMATION_NUMBER8 INFORMATION_NUMBER9 INFORMATION_NUMBER10 INFORMATION_NUMBER11 INFORMATION_NUMBER12 INFORMATION_NUMBER13 INFORMATION_NUMBER14 INFORMATION_NUMBER15 INFORMATION_NUMBER16 INFORMATION_NUMBER17 INFORMATION_NUMBER18 INFORMATION_NUMBER19 INFORMATION_NUMBER20 INFORMATION_DATE1 INFORMATION_DATE2 INFORMATION_DATE3 INFORMATION_DATE4 INFORMATION_DATE5 INFORMATION_DATE6 INFORMATION_DATE7 INFORMATION_DATE8 INFORMATION_DATE9 INFORMATION_DATE10 INFORMATION_DATE11 INFORMATION_DATE12 INFORMATION_DATE13 INFORMATION_DATE14 INFORMATION_DATE15 LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID EVENT_ACTION_NAME DESCRIPTION OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ALERT_ID ALERT_TEMPLATE_ID

Query

SQL_Statement

SELECT B.EVENT_ACTION_ID, B.EFFECTIVE_START_DATE, B.EFFECTIVE_END_DATE, B.EVENT_ACTION_TYPE_ID, B.BASE_NAME, B.REPORT_TYPE, B.ACTION_SUBMISSION, B.ENTERPRISE_ID, B.LOOKBACK_TIME_DEF_ID, B.INFORMATION_CHAR1, B.INFORMATION_CHAR2, B.INFORMATION_CHAR3, B.INFORMATION_CHAR4, B.INFORMATION_CHAR5, B.INFORMATION_CHAR6, B.INFORMATION_CHAR7, B.INFORMATION_CHAR8, B.INFORMATION_CHAR9, B.INFORMATION_CHAR10, B.INFORMATION_CHAR11, B.INFORMATION_CHAR12, B.INFORMATION_CHAR13, B.INFORMATION_CHAR14, B.INFORMATION_CHAR15, B.INFORMATION_CHAR16, B.INFORMATION_CHAR17, B.INFORMATION_CHAR18, B.INFORMATION_CHAR19, B.INFORMATION_CHAR20, B.INFORMATION_CHAR21, B.INFORMATION_CHAR22, B.INFORMATION_CHAR23, B.INFORMATION_CHAR24, B.INFORMATION_CHAR25, B.INFORMATION_CHAR26, B.INFORMATION_CHAR27, B.INFORMATION_CHAR28, B.INFORMATION_CHAR29, B.INFORMATION_CHAR30, B.INFORMATION_NUMBER1, B.INFORMATION_NUMBER2, B.INFORMATION_NUMBER3, B.INFORMATION_NUMBER4, B.INFORMATION_NUMBER5, B.INFORMATION_NUMBER6, B.INFORMATION_NUMBER7, B.INFORMATION_NUMBER8, B.INFORMATION_NUMBER9, B.INFORMATION_NUMBER10, B.INFORMATION_NUMBER11, B.INFORMATION_NUMBER12, B.INFORMATION_NUMBER13, B.INFORMATION_NUMBER14, B.INFORMATION_NUMBER15, B.INFORMATION_NUMBER16, B.INFORMATION_NUMBER17, B.INFORMATION_NUMBER18, B.INFORMATION_NUMBER19, B.INFORMATION_NUMBER20, B.INFORMATION_DATE1, B.INFORMATION_DATE2, B.INFORMATION_DATE3, B.INFORMATION_DATE4, B.INFORMATION_DATE5, B.INFORMATION_DATE6, B.INFORMATION_DATE7, B.INFORMATION_DATE8, B.INFORMATION_DATE9, B.INFORMATION_DATE10, B.INFORMATION_DATE11, B.INFORMATION_DATE12, B.INFORMATION_DATE13, B.INFORMATION_DATE14, B.INFORMATION_DATE15, B.LEGISLATION_CODE, B.LEGISLATIVE_DATA_GROUP_ID, TL.EVENT_ACTION_NAME, TL.DESCRIPTION, B.OBJECT_VERSION_NUMBER , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATE_LOGIN , B.ALERT_ID, B.ALERT_TEMPLATE_ID FROM PAY_EVENT_ACTIONS_F B, PAY_EVENT_ACTIONS_TL TL WHERE B.EVENT_ACTION_ID = TL.EVENT_ACTION_ID AND TL.LANGUAGE = USERENV('LANG')