Oracle Web ADI Scripts

-- The main tables in ADI are as follows:

BNE_CONTENTS_TL

BNE_INTEGRATORS_TL

BNE_INTERFACES_TL

BNE_INTERFACE_COLS_TL

BNE_LAYOUTS_TL

BNE_LAYOUT_COLS

BNE_MAPPINGS_TL

-- Sample script to print out integrator details. Note only update integrators have apis. Reporting_Flag='N' Otherwise they are associated with the _INTFC entity

SELECT DISTINCT

  substrb(bit.application_id,1,12) APP_ID,

  substrb(bit.user_name,1,35) INTEGRATOR_NAME,

  bl.reporting_flag,

  substrb(blcv.layout_code,1,35) INTEGRATOR_LAYOUT,

  substrb(biv.user_name,1,30) ASSOC_VIEW,

  substrb(biv.interface_name,1,20) API,

  substrb(biv.upload_type,1,3) TYPE

FROM

  bne_integrators_tl bit,

  bne_layout_cols_v blcv,

  bne_layouts_b bl,

  bne_interfaces_vl biv

WHERE

  bit.INTEGRATOR_CODE  = biv.INTEGRATOR_CODE

AND biv.interface_code = blcv.INTERFACE_CODE

AND bit.integrator_code=bl.integrator_code

AND upper(bit.user_name) LIKE upper('%&&Integrator_name%')

ORDER BY

  bl.reporting_flag

 

-- Sample script to print out all GENERAL integrators for different applications

SELECT

  application_id,

  language,

  source_lang,

  INTEGRATOR_CODE,

  SUBSTR(USER_NAME,1,30)

FROM

  BNE_INTEGRATORS_TL

WHERE

  APPLICATION_ID IN (800,nnn,etc)

AND INTEGRATOR_CODE LIKE 'GENERAL%'

ORDER BY

  application_id

 

-- Sample script to find integrators associated with a form function

SELECT

  security_code Integrator,

  security_type Type,

  security_value FUNCTION

FROM

  bne_security_rules

WHERE

  application_id   =800

AND security_value = '&function_name'