WEBADI 相关表查询

select * from bne_integrators_b where integrator_code = 'GENERAL_3_INTG'; -- 集成器信息
select * from bne_interfaces_tl where interface_code like  'GENERAL_3%';  -- 接口信息
select * from bne_interfaces_b where integrator_code = 'GENERAL_3_INTG';

select * from bne_interface_cols_b where interface_code = 'GENERAL_3_INTG_INTF1'; -- 接口列信息
select * from bne_interface_cols_tl where interface_code like  'GENERAL_3%';
select * from BNE_PARAM_LISTS_B where param_list_code in ('GENERAL_3','GENERAL_3_INTG_UPL1'); --参数列表
select * from bne_param_lists_tl where param_list_code in ('GENERAL_3','GENERAL_3_INTG_UPL1');
SELECT * FROM BNE_ATTRIBUTES WHERE ATTRIBUTE_CODE LIKE '%GENERAL_3_INTG_UPL1%'; --