在form级触发器 when-new-form-instance中用参数获取lov需要的值集ID
:Parameter.P_ACC_FLEX_ID := cux_gl_utl.get_coa_acc_flex_id;
--在lov中填入如下代码 SELECT FFVV.FLEX_VALUE, FFVV.DESCRIPTION FROM FND_FLEX_VALUES_VL FFVV WHERE FFVV.FLEX_VALUE_SET_ID = :Parameter.P_ACC_FLEX_ID AND FFVV.ENABLED_FLAG = 'Y' AND (FFVV.START_DATE_ACTIVE IS NULL OR FFVV.START_DATE_ACTIVE < SYSDATE) AND (FFVV.END_DATE_ACTIVE IS NULL OR FFVV.END_DATE_ACTIVE > SYSDATE) ORDER BY FFVV.FLEX_VALUE