DBA Data[Home] [Help]

VIEW: APPS.IBC_FILE_EXTN_MAPPINGS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.MAPPING_ID, B.CONTENT_TYPE_CODE, T.EXTENSION, T.DESCRIPTION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE,B.last_update_login FROM IBC_FILE_EXTN_MAPPINGS_TL T, IBC_FILE_EXTN_MAPPINGS_B B WHERE B.MAPPING_ID = T.MAPPING_ID AND T.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.MAPPING_ID
, B.CONTENT_TYPE_CODE
, T.EXTENSION
, T.DESCRIPTION
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM IBC_FILE_EXTN_MAPPINGS_TL T
, IBC_FILE_EXTN_MAPPINGS_B B
WHERE B.MAPPING_ID = T.MAPPING_ID
AND T.LANGUAGE = USERENV('LANG')