FAI_WORKFLOWS_VL

Details

• Schema: FUSION

• Object owner: FAI

• Object type: VIEW

Columns

Name

WORKFLOW_ID VERSION SOURCE_WORKFLOW_ID USE_CASE_ID WORKFLOW_CODE SEEDED_FLAG OWNER_ID OWNER_NAME STATUS ARCHITECTURE ACCESS_MODIFIER SPECIFICATION FAMILY PRODUCT HIDDEN_FLAG START_QUESTION_1 START_QUESTION_2 START_QUESTION_3 START_QUESTION_4 START_QUESTION_5 FOLLOW_UP_PROMPT_ENABLED FOLLOW_UP_PROMPT MODEL_CONFIG_ID MAX_INTERACTIONS START_AGENT_ID INTERNAL_NAME INTERNAL_DESCRIPTION MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CUSTOM_FLAG SOURCE_WORKFLOW_CODE IS_TEMPLATE EMAIL_CONFIG_CODE JOB_REQUEST_ID NAME DESCRIPTION

Query

SQL_Statement

SELECT B.WORKFLOW_ID WORKFLOW_ID, B.VERSION VERSION, B.SOURCE_WORKFLOW_ID SOURCE_WORKFLOW_ID, B.USE_CASE_ID USE_CASE_ID, B.WORKFLOW_CODE WORKFLOW_CODE, B.SEEDED_FLAG SEEDED_FLAG, B.OWNER_ID OWNER_ID, B.OWNER_NAME OWNER_NAME, B.STATUS STATUS, B.ARCHITECTURE ARCHITECTURE, B.ACCESS_MODIFIER ACCESS_MODIFIER, B.SPECIFICATION, B.FAMILY, B.PRODUCT, B.HIDDEN_FLAG, B.START_QUESTION_1, B.START_QUESTION_2, B.START_QUESTION_3, B.START_QUESTION_4, B.START_QUESTION_5, B.FOLLOW_UP_PROMPT_ENABLED, B.FOLLOW_UP_PROMPT, B.MODEL_CONFIG_ID, B.MAX_INTERACTIONS, B.START_AGENT_ID, B.INTERNAL_NAME, B.INTERNAL_DESCRIPTION, B.MODULE_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.CUSTOM_FLAG, B.SOURCE_WORKFLOW_CODE, B.IS_TEMPLATE, B.EMAIL_CONFIG_CODE, B.JOB_REQUEST_ID, T.NAME NAME, T.DESCRIPTION DESCRIPTION FROM FAI_WORKFLOWS_B B, FAI_WORKFLOWS_TL T WHERE B.WORKFLOW_ID=T.WORKFLOW_ID AND T.LANGUAGE=USERENV('LANG')