VIEW: APPS.BNE_MAPPINGS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')