2320: AND FL_COL.END_USER_COLUMN_NAME = INTF.ATTR_INT_NAME
2321: AND FL_COL.APPLICATION_ID = 431
2322: AND (INTF.ATTR_VALUE_NUM = FL_COL.FLEX_VALUE_SET_ID
2323: OR INTF.ATTR_VALUE_NUM IN (SELECT VS.VALUE_SET_ID
2324: FROM EGO_VALUE_SET_EXT VS
2325: WHERE VS.PARENT_VALUE_SET_ID = FL_COL.FLEX_VALUE_SET_ID)
2326: )
2327: )
2328: );
3112: END) NOT IN ( SELECT val.FLEX_VALUE
3113: FROM
3114: FND_FLEX_VALUES_VL val,
3115: EGO_VS_VALUES_DISP_ORDER disp_order,
3116: EGO_VALUE_SET_EXT ext
3117: WHERE val.FLEX_VALUE_ID = disp_order.VALUE_SET_VALUE_ID
3118: AND disp_order.VALUE_SET_ID = SVA.VALUE_SET_ID
3119: AND val.FLEX_VALUE_SET_ID = ext.PARENT_VALUE_SET_ID
3120: AND ext.VALUE_SET_ID = disp_order.VALUE_SET_ID