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