SELECT BNEINTERFACESBEO.APPLICATION_ID
, BNEINTERFACESBEO.INTERFACE_CODE
, BNEINTERFACESBEO.OBJECT_VERSION_NUMBER
, BNEINTERFACESBEO.INTEGRATOR_APP_ID
, BNEINTERFACESBEO.INTEGRATOR_CODE
, BNEINTERFACESBEO.INTERFACE_NAME
, BNEINTERFACESBEO.UPLOAD_TYPE
, BNEINTERFACESBEO.UPLOAD_OBJ_NAME
, BNEINTERFACESBEO.UPLOAD_PARAM_LIST_APP_ID
, BNEINTERFACESBEO.UPLOAD_PARAM_LIST_CODE
, BNEINTERFACESBEO.UPLOAD_ORDER
, BNEINTERFACESBEO.USER_NAME
, BNEINTERFACESBEO.CREATED_BY
, BNEINTERFACESBEO.CREATION_DATE
, BNEINTERFACESBEO.LAST_UPDATED_BY
, BNEINTERFACESBEO.LAST_UPDATE_LOGIN
, BNEINTERFACESBEO.LAST_UPDATE_DATE
, BNEATTRIBUTESEO.APPLICATION_ID AS APPLICATION_ID1
, BNEATTRIBUTESEO.ATTRIBUTE_CODE
, BNEATTRIBUTESEO.ATTRIBUTE1
, BNEATTRIBUTESEO.ATTRIBUTE2
, BNEATTRIBUTESEO.ATTRIBUTE3
, BNEATTRIBUTESEO.ATTRIBUTE4
, BNEATTRIBUTESEO.ATTRIBUTE5
, (CASE BNEINTERFACESBEO.UPLOAD_TYPE
WHEN 0 THEN 'Custom'
WHEN 1 THEN 'Table'
WHEN 2 THEN INITCAP (BNEATTRIBUTESEO.ATTRIBUTE1)
WHEN 3 THEN 'Validation Only'
WHEN 4 THEN 'None'
WHEN 5 THEN 'Reference PL/SQL API'
ELSE 'Invalid Type'
END)
AS UPLOAD_TYPE_TEXT
, (CASE BNEINTERFACESBEO.UPLOAD_TYPE
WHEN 0 THEN BNEINTERFACESBEO.UPLOAD_OBJ_NAME
WHEN 2 THEN BNEATTRIBUTESEO.ATTRIBUTE2
ELSE BNEINTERFACESBEO.INTERFACE_NAME
END)
AS UPLOAD_ENTITY_NAME
, (CASE BNEINTERFACESBEO.UPLOAD_TYPE WHEN 2 THEN 0 ELSE 1 END)
AS ATTRIBUTES_READONLY
, BNE_INTEGRATORS_VL.*
FROM BNE_INTERFACES_VL BNEINTERFACESBEO
, BNE.BNE_ATTRIBUTES BNEATTRIBUTESEO
, BNE_PARAM_LISTS_VL BNEPARAMLISTSBEO
, BNE_INTEGRATORS_VL
WHERE BNEPARAMLISTSBEO.PARAM_LIST_CODE(+) =
BNEINTERFACESBEO.UPLOAD_PARAM_LIST_CODE
AND BNEPARAMLISTSBEO.APPLICATION_ID(+) =
BNEINTERFACESBEO.UPLOAD_PARAM_LIST_APP_ID
AND BNEATTRIBUTESEO.ATTRIBUTE_CODE(+) = BNEPARAMLISTSBEO.ATTRIBUTE_CODE
AND BNEATTRIBUTESEO.APPLICATION_ID(+) = BNEPARAMLISTSBEO.ATTRIBUTE_APP_ID
-- AND (INTEGRATOR_APP_ID = :1 AND INTEGRATOR_CODE = :2)
AND BNEINTERFACESBEO.INTEGRATOR_CODE = BNE_INTEGRATORS_VL.INTEGRATOR_CODE
AND BNE_INTEGRATORS_VL.USER_NAME = 'CUX_WEBADI_DEMO'
ORDER BY BNEINTERFACESBEO.UPLOAD_ORDER ASC
, BNEINTERFACESBEO.USER_NAME ASC
, BNEINTERFACESBEO.APPLICATION_ID ASC
, BNEINTERFACESBEO.INTERFACE_CODE ASC