FND Design Data [Home] [Help]

View: BNE_MAPPINGS_VL

Product: BNE - Web Applications Desktop Integrator
Description: BNE_MAPPINGS_VL is a standard translation view over the BNE_MAPPINGS entity.
Implementation/DBA Data: ViewAPPS.BNE_MAPPINGS_VL
View Text

SELECT M.ROWID ROW_ID
, M.APPLICATION_ID
, M.MAPPING_CODE
, M.OBJECT_VERSION_NUMBER
, M.INTEGRATOR_APP_ID
, M.INTEGRATOR_CODE
, M.REPORTING_FLAG
, M.REPORTING_INTERFACE_APP_ID
, M.REPORTING_INTERFACE_CODE
, T.USER_NAME
, M.CREATED_BY
, M.CREATION_DATE
, M.LAST_UPDATED_BY
, M.LAST_UPDATE_LOGIN
, M.LAST_UPDATE_DATE
FROM BNE_MAPPINGS_B M
, BNE_MAPPINGS_TL T
WHERE M.APPLICATION_ID = T.APPLICATION_ID
AND M.MAPPING_CODE = T.MAPPING_CODE
AND T.LANGUAGE=USERENV('LANG')

Columns

Name
ROW_ID
APPLICATION_ID
MAPPING_CODE
OBJECT_VERSION_NUMBER
INTEGRATOR_APP_ID
INTEGRATOR_CODE
REPORTING_FLAG
REPORTING_INTERFACE_APP_ID
REPORTING_INTERFACE_CODE
USER_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE