ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 476D12A8C9355EFFE0630100007F487EY select odaoev.application_name application, odaoev.name entity, odaaev.defaulting_sequence, odaaev.name attribute, xxen_util.yes(odaaev.defaulting_condn_ref_flag) include_in_building_conditions, odacv.display_name condition, (select listagg(odcev.attribute_display_name||odcev.value_op||odcev.value_string,chr(10)) within group (order by odcev.group_number, odcev.attribute_code) from oe_def_condn_elems_v odcev where odacv.condition_id=odcev.condition_id and rownum=1) validation_rule, odacv.precedence, xxen_util.yes(odacv.enabled_flag) enabled, xxen_util.yes(odacv.system_flag) seeded, odadr.sequence_no sequence, xxen_util.meaning(odadr.src_type,'DEFAULTING_SOURCE_TYPE',660) source_type, case odadr.src_type when 'CONSTANT' then odadr.src_constant_value when 'PROFILE_OPTION' then odadr.src_profile_option when 'API' then odadr.src_api_pkg||'.'||odadr.src_api_fn when 'API_MULTIREC' then odadr.src_api_pkg||'.'||odadr.src_api_fn when 'SYSTEM' then odadr.src_system_variable_expr when 'RELATED_RECORD' then (select odaaev2.database_object_display_name||'.'||odaaev2.name from oe_def_ak_attr_ext_v odaaev2 where odadr.src_database_object_name=odaaev2.database_object_name and odadr.src_attribute_code=odaaev2.attribute_code) when 'SAME_RECORD' then (select odaaev2.name from oe_def_ak_attr_ext_v odaaev2 where odadr.src_database_object_name=odaaev2.database_object_name and odadr.src_attribute_code=odaaev2.attribute_code) end source_value, xxen_util.user_name(odacv.created_by) created_by, xxen_util.client_time(odacv.creation_date) creation_date, xxen_util.user_name(odacv.last_updated_by) last_updated_by, xxen_util.client_time(odacv.last_update_date) last_update_date, xxen_util.user_name(odadr.created_by) rule_created_by, xxen_util.client_time(odadr.creation_date) rule_creation_date, xxen_util.user_name(odadr.last_updated_by) rule_last_updated_by, xxen_util.client_time(odadr.last_update_date) rule_last_update_date, odaoev.application_id, odaaev.database_object_name, odaaev.attribute_code, odacv.attr_def_condition_id, odadr.attr_def_rule_id from oe_def_ak_obj_ext_v odaoev, oe_def_ak_attr_ext_v odaaev, oe_def_attr_condns_v odacv, oe_def_attr_def_rules odadr where 1=1 and odaoev.database_object_name=odaaev.database_object_name and odaaev.defaulting_enabled_flag='Y' and odaaev.database_object_name=odacv.database_object_name(+) and odaaev.attribute_code=odacv.attribute_code(+) and odacv.attr_def_condition_id=odadr.attr_def_condition_id(+) order by odaoev.application_name, odaoev.name, odaaev.defaulting_sequence, odaaev.name, odacv.precedence, odadr.sequence_no ONT US ONT Defaulting Rules Shows the complete Order Management defaulting rules setup Enginatics 1=1 1 10 1=1 odaoev.application_name=:application LOV custom Y select distinct odaoev.application_name value, null description from oe_def_ak_obj_ext_v odaoev order by 1 Order Management US Application 2 20 1=1 odaoev.name=:entity LOV custom Y select distinct odaoev.name value, null description from oe_def_ak_obj_ext_v odaoev where :$flex$.application is null or odaoev.application_name=:$flex$.application order by 1 US Entity 3 30 1=1 odaaev.name=:attribute LOV custom Y select distinct odaaev.name value, null description from oe_def_ak_attr_ext_v odaaev where :$flex$.entity is null or odaaev.database_object_display_name=:$flex$.entity order by 1 US Attribute 4 40 1=1 odacv.display_name=:defaulting_condition LOV custom Y select distinct odacv.display_name value, odacv.description from oe_def_attr_condns_v odacv where :$flex$.entity is null or odacv.database_object_display_name=:$flex$.entity order by 1 US Condition 5 50 1=1 odacv.enabled_flag=:enabled LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Enabled 6 60 1=1 odacv.system_flag=:seeded LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description US Seeded 7 70 1=1 xxen_util.meaning(odadr.src_type,'DEFAULTING_SOURCE_TYPE',660)=:source_type LOV custom Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type='DEFAULTING_SOURCE_TYPE' and flvv.lookup_code in (select odadr.src_type from oe_def_attr_def_rules odadr) order by flvv.meaning US Source Type