Folder Joins

List of joins from one folder to another.

Example Query
SELECT
distinct
decode(decode(SUBSTR(o100605.key_name, 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No'), 'Yes', EUL5_get_join(o100592.exp_id), o100605.key_name) join_name
, EUL5_get_join(o100592.exp_id, 'N') join_condition
, decode(o100605.fk_mandatory, 1, 'Always exist in master folder', 'Might not exist in master folder') join_details
, nvl(decode(o100605.fk_mstr_no_detail, 1, 'Outer join on detail' || CHR(10), NULL) || decode(o100605.fk_dtl_no_master, 1, 'Outer join on master' || CHR(10), NULL) || decode(o100605.fk_one_to_one, 1, 'One to one join', NULL), 'None') optional_join_configuration
, decode(SUBSTR(o100605.key_name, 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No') Auto
,o100607.obj_name folder
FROM EUL5_ba_obj_links o100582,
EUL5_objs o100607,
EUL5_expressions o100592,
EUL5_key_cons o100605
WHERE((o100607.obj_id = o100582.bol_obj_id)
AND(o100605.key_id = o100592.jp_key_id)
AND(o100607.obj_id = o100605.fk_obj_id_remote))
and ( o100607.obj_id = 101325 or lower( o100607.obj_name) like lower('Activity Base Rate') )