WEBADI Interface used Package and View Query

   SELECT BIT.USER_NAME WEB_ADI, BA.ATTRIBUTE2 "PACKAGE", BCT.USER_NAME "VIEW"

  FROM BNE_INTEGRATORS_TL BIT,

       BNE_ATTRIBUTES BA,

       BNE_CONTENTS_TL BCT

 WHERE substr(BIT.INTEGRATOR_CODE,1,length(BIT.INTEGRATOR_CODE)-5)||'_P0_ATT' = BA.ATTRIBUTE_CODE

   AND BIT.APPLICATION_ID = BCT.APPLICATION_ID

   AND BIT.LANGUAGE = 'US'

   AND BCT.LANGUAGE = 'US'

   AND BA.ATTRIBUTE1 = 'PROCEDURE'

   AND BIT.APPLICATION_ID = BA.APPLICATION_ID

   AND BCT.CONTENT_CODE = substr(BIT.INTEGRATOR_CODE,1,length(BIT.INTEGRATOR_CODE)-5)||'_CNT'

   AND BIT.USER_NAME LIKE 'My Integrator Name '

   order by BIT.USER_NAME;