Folder Filters

SELECT decode(o100592.exp_type, 'FIL', (EUL5_get_autogen_item_name(o100592.exp_id)), NULL) used_in_condition,
decode(o100592.exp_type, 'FIL', NULL, (EUL5_get_autogen_item_name(o100592.exp_id))) item,
o100577.ba_name ,
EUL5_get_object(o100593.ped_exp_id) base_object,
o100592_2.exp_name filter_name,
decode(o100592_2.fil_runtime_filter, 0, 'Mandatory', 'Optional') filter_type,
o100607_2.obj_name folder_name
FROM EUL5_expressions o100592,
EUL5_bas o100577,
EUL5_ba_obj_links o100582,
EUL5_objs o100607,
EUL5_expressions o100592_2,
EUL5_exp_deps o100593,
EUL5_objs o100607_2
WHERE((o100577.ba_id(+) = o100582.bol_ba_id)
AND(o100607.obj_id = o100582.bol_obj_id)
AND(o100592_2.exp_id = o100593.pd_p_id)
AND(o100607_2.obj_id = o100592_2.fil_obj_id)
AND(o100607.obj_id = o100607_2.obj_id)
AND(o100593.ped_exp_id = o100592.exp_id))
and ( o100577.ba_id = 100018 or lower(o100577.ba_name) like lower('ABM Activities') )
order by o100577.ba_name