ZCA_OML_USECASE_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
USECASE_CODE DATA_SOURCE_NAME DATA_SOURCE_TYPE DATA_SOURCE_PK TARGET_COLUMN MODEL_TYPE SHOW_UI_FLAG READ_ONLY_FLAG PRE_SEEDED_FLAG ADDITIONAL_METADATA CRITERIA_FILTER_EXPR CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER USECASE_NAME USECASE_DESCRIPTION SOURCE_LANG LANGUAGE

Query

SQL_Statement

SELECT zca_oml_usecase_b.USECASE_CODE, zca_oml_usecase_b.DATA_SOURCE_NAME, zca_oml_usecase_b.DATA_SOURCE_TYPE, zca_oml_usecase_b.DATA_SOURCE_PK, zca_oml_usecase_b.TARGET_COLUMN, zca_oml_usecase_b.MODEL_TYPE, zca_oml_usecase_b.SHOW_UI_FLAG, zca_oml_usecase_b.READ_ONLY_FLAG, zca_oml_usecase_b.PRE_SEEDED_FLAG, zca_oml_usecase_b.ADDITIONAL_METADATA, zca_oml_usecase_b.CRITERIA_FILTER_EXPR, zca_oml_usecase_b.CREATED_BY, zca_oml_usecase_b.CREATION_DATE, zca_oml_usecase_b.LAST_UPDATE_DATE, zca_oml_usecase_b.LAST_UPDATED_BY, zca_oml_usecase_b.LAST_UPDATE_LOGIN, zca_oml_usecase_b.OBJECT_VERSION_NUMBER, zca_oml_usecase_tl.USECASE_NAME, zca_oml_usecase_tl.USECASE_DESCRIPTION, zca_oml_usecase_tl.SOURCE_LANG, zca_oml_usecase_tl.LANGUAGE FROM zca_oml_usecase_b, zca_oml_usecase_tl WHERE zca_oml_usecase_b.USECASE_CODE = zca_oml_usecase_tl.USECASE_CODE and zca_oml_usecase_tl.LANGUAGE = USERENV('LANG')