VIEW: APPS.BNE_INTERFACES_VL

Source

View Text - Preformatted

SELECT I.ROWID ROW_ID, I.APPLICATION_ID, I.INTERFACE_CODE, I.OBJECT_VERSION_NUMBER, I.INTEGRATOR_APP_ID, I.INTEGRATOR_CODE, I.INTERFACE_NAME, I.UPLOAD_TYPE, I.UPLOAD_OBJ_NAME, I.UPLOAD_PARAM_LIST_APP_ID, I.UPLOAD_PARAM_LIST_CODE, I.UPLOAD_ORDER, T.USER_NAME, I.CREATED_BY, I.CREATION_DATE, I.LAST_UPDATED_BY, I.LAST_UPDATE_LOGIN, I.LAST_UPDATE_DATE FROM BNE_INTERFACES_B I, BNE_INTERFACES_TL T WHERE I.APPLICATION_ID = T.APPLICATION_ID AND I.INTERFACE_CODE = T.INTERFACE_CODE AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT I.ROWID ROW_ID
, I.APPLICATION_ID
, I.INTERFACE_CODE
, I.OBJECT_VERSION_NUMBER
, I.INTEGRATOR_APP_ID
, I.INTEGRATOR_CODE
, I.INTERFACE_NAME
, I.UPLOAD_TYPE
, I.UPLOAD_OBJ_NAME
, I.UPLOAD_PARAM_LIST_APP_ID
, I.UPLOAD_PARAM_LIST_CODE
, I.UPLOAD_ORDER
, T.USER_NAME
, I.CREATED_BY
, I.CREATION_DATE
, I.LAST_UPDATED_BY
, I.LAST_UPDATE_LOGIN
, I.LAST_UPDATE_DATE
FROM BNE_INTERFACES_B I
, BNE_INTERFACES_TL T
WHERE I.APPLICATION_ID = T.APPLICATION_ID
AND I.INTERFACE_CODE = T.INTERFACE_CODE
AND T.LANGUAGE = USERENV('LANG')