FFS_REP_MESSAGES_V

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
SENT ROUTE_ID MESSAGE_ID STATUS DESCRIPTION METHOD ACTIVITY_ID MESSAGE_TRIGGER RECIPIENT PAS_FLAG

Query

SQL_Statement

SELECT ffs_message_log.sent, ffs_message_log.route_id, ffs_message_log.message_id, ffs_message_log.status, ffs_message_log.description, ffs_message_log.method, ffs_message_log.activity_id, ffs_message_log.message_trigger, NVL(ffs_message_step.recipient, '') AS recipient, case when ffs_survey.survey_id is not null THEN 'Y' ELSE 'N' END AS pas_flag FROM ffs_message_log LEFT JOIN ffs_message_step ON ffs_message_log.step_id = ffs_message_step.step_id LEFT JOIN ffs_survey ON ffs_message_step.survey_id = ffs_survey.survey_id AND ffs_survey.type = 'pas' WHERE ffs_message_log.status NOT IN ('new', 'sending')