[Home] [Help]
View: IBY_EXTRACTS_VL
View Text
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')
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 |