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 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN 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.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, 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')