This topic provides information about Combined LOV.

User can use a combination of Lov's from external and internal, where we will provide details of external Lov's bind variable and reduction field details.

Here user will provide details for external LOV. When generated after the modifications, INC will be generated with the below kind of data.

UPDATE CSTB_LOV_INFO SET LOV_TYPE = 'E' WHERE FUNCTION_ID='STDCIF' AND LOV_ID IN ('LOV_ACCOUNT','LOV_ACCOUNT_OFF')
/
UPDATE CSTB_LOV_INFO SET LOV_TYPE = 'C' WHERE FUNCTION_ID='STDCIF' AND LOV_ID IN ('LOV_AML_CUST_GRP')
/
DELETE CSTB_CMB_LOV_INFO A WHERE A.FUNCTION_ID IN ('STDCIF');
INSERT INTO CSTB_CMB_LOV_INFO (FUNCTION_ID, LOV_ID, EXTERNAL_LOV_ID, LOV_FUNCTION, REDUCTION_LIST, BIND_LIST) VALUES ('STDCIF','LOV_AML_CUST_GRP','LOV_EXT_AML_CUST','fn_function()','','1~')
/
COMMIT;