1.2 Overview of LOV Enhancer
This topic provides an overview of LOV Enhancer.
Lov Enhancer is used to map Lov's of Screens to External or Combined Lov's.
External LOV
Lov of a screen is mapped to External Lov. All the data populated and data fetched in the lov will be from the external system. The user has to select the lov as External on the screen.
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;