1. Tables and Views for Sales, Fusion Service, and Field Service
  2. FFS_REP_PAS_QUESTION_V

FFS_REP_PAS_QUESTION_V

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: VIEW

Columns

Name

TRANSLATION_ID

LANGUAGE_ID

TEXT

Query

SQL_Statement

SELECT tr.translation_id,

tr.language_id,

tr.text

FROM ffs_translation tr

WHERE translation_table = 'survey_question.question_id'

AND EXISTS (

SELECT 1

FROM ffs_survey_question sq

JOIN ffs_survey ON sq.survey_id = ffs_survey.survey_id

WHERE ffs_survey.type = 'pas'

AND sq.question_id = tr.translation_id

)