VIEW: APPS.BNE_INTEGRATORS_VL

Source

View Text - Preformatted

SELECT I.ROWID ROW_ID, I.APPLICATION_ID, I.INTEGRATOR_CODE, I.OBJECT_VERSION_NUMBER, I.ENABLED_FLAG, I.UPLOAD_PARAM_LIST_APP_ID, I.UPLOAD_PARAM_LIST_CODE, I.UPLOAD_SERV_PARAM_LIST_APP_ID, I.UPLOAD_SERV_PARAM_LIST_CODE, I.IMPORT_PARAM_LIST_APP_ID, I.IMPORT_PARAM_LIST_CODE, I.UPLOADER_CLASS, I.DATE_FORMAT, I.IMPORT_TYPE, I.CREATE_DOC_LIST_APP_ID, I.CREATE_DOC_LIST_CODE, I.NEW_SESSION_FLAG, T.USER_NAME, T.UPLOAD_TITLE_BAR, T.UPLOAD_HEADER, I.CREATED_BY, I.CREATION_DATE, I.LAST_UPDATED_BY, I.LAST_UPDATE_LOGIN, I.LAST_UPDATE_DATE, I.LAYOUT_RESOLVER_CLASS, I.LAYOUT_VERIFIER_CLASS, I.SESSION_CONFIG_CLASS, I.SESSION_PARAM_LIST_APP_ID, I.SESSION_PARAM_LIST_CODE, I.DISPLAY_FLAG, I.SOURCE FROM BNE_INTEGRATORS_B I, BNE_INTEGRATORS_TL T WHERE I.APPLICATION_ID = T.APPLICATION_ID AND I.INTEGRATOR_CODE = T.INTEGRATOR_CODE AND T.LANGUAGE=USERENV('LANG')

View Text - HTML Formatted

SELECT I.ROWID ROW_ID
, I.APPLICATION_ID
, I.INTEGRATOR_CODE
, I.OBJECT_VERSION_NUMBER
, I.ENABLED_FLAG
, I.UPLOAD_PARAM_LIST_APP_ID
, I.UPLOAD_PARAM_LIST_CODE
, I.UPLOAD_SERV_PARAM_LIST_APP_ID
, I.UPLOAD_SERV_PARAM_LIST_CODE
, I.IMPORT_PARAM_LIST_APP_ID
, I.IMPORT_PARAM_LIST_CODE
, I.UPLOADER_CLASS
, I.DATE_FORMAT
, I.IMPORT_TYPE
, I.CREATE_DOC_LIST_APP_ID
, I.CREATE_DOC_LIST_CODE
, I.NEW_SESSION_FLAG
, T.USER_NAME
, T.UPLOAD_TITLE_BAR
, T.UPLOAD_HEADER
, I.CREATED_BY
, I.CREATION_DATE
, I.LAST_UPDATED_BY
, I.LAST_UPDATE_LOGIN
, I.LAST_UPDATE_DATE
, I.LAYOUT_RESOLVER_CLASS
, I.LAYOUT_VERIFIER_CLASS
, I.SESSION_CONFIG_CLASS
, I.SESSION_PARAM_LIST_APP_ID
, I.SESSION_PARAM_LIST_CODE
, I.DISPLAY_FLAG
, I.SOURCE
FROM BNE_INTEGRATORS_B I
, BNE_INTEGRATORS_TL T
WHERE I.APPLICATION_ID = T.APPLICATION_ID
AND I.INTEGRATOR_CODE = T.INTEGRATOR_CODE
AND T.LANGUAGE=USERENV('LANG')