--本文档主要是借鉴标准的集成器HR INTEGRATOR SETUP相关LOV栏位的设置实现
--集成器名称查询
SELECT *
FROM BNE_INTEGRATORS_VL BIV
WHERE BIV.USER_NAME IN ('MEW 发票付款导入(多OU)'
,'HR Integrator Setup')
AND BIV.ENABLED_FLAG = 'Y';
--集成器模版布局名称查询
SELECT *
FROM BNE_INTERFACES_VL BIVL
WHERE BIVL.INTEGRATOR_CODE IN
('GENERAL_1281_INTG'
,'HR_SETUP_SETUP_INTG');
--集成器模版布局列查询及修改必要列,如下表格,红色字体为必需要输入的。
SELECT B.*
FROM BNE_INTERFACE_COLS_B B
WHERE INTERFACE_CODE IN ('HR_SETUP_SETUP_INTG_INTF'
,'GENERAL_1281_INTF')
AND B.INTERFACE_COL_NAME IN ('P_ORG_ID'
,'P_APPLICATION_ID')
FOR UPDATE;