IRC_REC_CAMPAIGNS_V

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name
ACTIVATED_ON_DATE CAMPAIGN_CODE CAMPAIGN_DURATION_CODE CAMPAIGN_ID CAMPAIGN_LANGUAGE_CODE CAMPAIGN_STATUS_CODE CAMPAIGN_TYPE_CODE CANCELLED_ON_DATE CLOSED_ON_DATE CREATED_BY CREATION_DATE ELIG_OBJ_ID ELIG_PRFL_ID JOURNEY_ID LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PURPOSE_CODE

Query

SQL_Statement

SELECT RECC.ACTIVATED_ON_DATE, RECC.CAMPAIGN_CODE, RECC.CAMPAIGN_DURATION_CODE, RECC.CAMPAIGN_ID, RECC.CAMPAIGN_LANGUAGE_CODE, RECC.CAMPAIGN_STATUS_CODE, RECC.CAMPAIGN_TYPE_CODE, RECC.CANCELLED_ON_DATE, RECC.CLOSED_ON_DATE, RECC.CREATED_BY, RECC.CREATION_DATE, RECC.ELIG_OBJ_ID, RECC.ELIG_PRFL_ID, RECC.JOURNEY_ID, RECC.LAST_UPDATED_BY, RECC.LAST_UPDATE_DATE, RECC.LAST_UPDATE_LOGIN, RECC.OBJECT_VERSION_NUMBER, RECC.PURPOSE_CODE FROM IRC_CAMPAIGNS_B RECC WHERE CAMPAIGN_TYPE_CODE = 'ORA_REC_CAMPAIGN'