ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8879D2E0530100007F1FF2 HR Operating Unit (all) Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 28C265764C7A54C0E0630100007F6E0D select haouv.name operating_unit, ospdv.name parameter_name, ospdv.description, xxen_util.yes(ospdv.seeded_flag) seeded, xxen_util.yes(ospdv.enabled_flag) enabled, xxen_util.meaning(ospdv.category_code,'OM_PARAMETER_CATEGORY',660) category, (select ffvs.flex_value_set_name from fnd_flex_value_sets ffvs where ospdv.value_set_id=ffvs.flex_value_set_id) flex_value_set_name, xxen_util.meaning(ospdv.open_orders_check_flag,'OPEN_ORDERS_ACTION',660) open_orders_check_flag, ospa.parameter_value, xxen_util.user_name(ospa.created_by) created_by, xxen_util.client_time(ospa.creation_date) creation_date, xxen_util.user_name(ospa.last_updated_by) last_updated_by, xxen_util.client_time(ospa.last_update_date) last_update_date, ospdv.parameter_code, ospdv.category_code from oe_sys_parameter_def_vl ospdv, oe_sys_parameters_all ospa, hr_all_organization_units_vl haouv where 1=1 and ospdv.parameter_code=ospa.parameter_code(+) and ospa.org_id=haouv.organization_id(+) order by haouv.name, ospdv.name Y US ONT System Parameters Enginatics 1=1 1 10 1=1 haouv.name=:operating_unit LOV HR Operating Unit (all) 8E2FF36EDE8879D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 2 20 1=1 ospdv.name=:parameter_name LOV custom Y select ospdv.name value, ospdv.description from oe_sys_parameter_def_vl ospdv order by ospdv.name US Parameter Name 3 25 1=1 ospdv.parameter_code=:parameter_code LOV custom Y select ospdv.parameter_code value, ospdv.description from oe_sys_parameter_def_vl ospdv order by ospdv.name US Parameter Code 4 30 1=1 ospdv.enabled_flag='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Enabled Only