FUN_WF_FACTS_VL

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
ROW_ID FACT_ID WORKFLOW_ID WF_OBJECT_ID PARENT_FACT_ID FACT_NAME FACT_ALIAS COLLECTION_NAME COLLECTION_KEY1 COLLECTION_KEY2 COLLECTION_KEY3 COLLECTION_KEY4 COLLECTION_KEY5 REPETITIVE_FLAG SEED_DATA_SOURCE MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.FACT_ID, B.WORKFLOW_ID, B.WF_OBJECT_ID, B.PARENT_FACT_ID, B.FACT_NAME, TL.FACT_ALIAS, B.COLLECTION_NAME, B.COLLECTION_KEY1, B.COLLECTION_KEY2, B.COLLECTION_KEY3, B.COLLECTION_KEY4, B.COLLECTION_KEY5, B.REPETITIVE_FLAG, B.SEED_DATA_SOURCE, B.MODULE_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM FUN_WF_FACTS_B B, FUN_WF_FACTS_TL TL WHERE TL.FACT_ID = B.FACT_ID AND TL.LANGUAGE = USERENV('LANG')