IBY_EXTRACTS_VL

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
ROW_ID DATASOURCE_CODE GEN_CODE_LANGUAGE GEN_CODE_PACKAGE GEN_CODE_ENTRY_POINT EXTRACT_ID EXTRACT_CODE EXTRACT_VERSION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER EXTRACT_DESC

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.DATASOURCE_CODE, B.GEN_CODE_LANGUAGE, B.GEN_CODE_PACKAGE, B.GEN_CODE_ENTRY_POINT, B.EXTRACT_ID, B.EXTRACT_CODE, B.EXTRACT_VERSION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.EXTRACT_DESC from IBY_EXTRACTS_TL T, IBY_EXTRACTS_B B where B.EXTRACT_ID = T.EXTRACT_ID and T.LANGUAGE = userenv('LANG')