ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2473869E053B46B63588994Y select d.database_object_display_name, d.attribute_display_name, d.precedence, d.display_name, d.system_flag, d.enabled_flag, k.sequence_no, l.meaning , decode (src_type, 'API', src_api_pkg || '.' || src_api_fn, 'CONSTANT', src_constant_value, 'SYSTEM', src_system_variable_expr, 'SEQUENCE', src_sequence_name, 'DATABASE', src_database_object_name || '.' || src_attribute_code, 'WAD_ATTR', ' ', 'WAD_OBJATTR',' ', src_constant_value) source , src_type, k.attribute_code, ONT_OEXDERUL_XMLP_PKG.sourcevalueformula(src_type, k.attribute_code, decode ( src_type , 'API' , src_api_pkg || '.' || src_api_fn , 'CONSTANT' , src_constant_value , 'SYSTEM' , src_system_variable_expr , 'SEQUENCE' , src_sequence_name , 'DATABASE' , src_database_object_name || '.' || src_attribute_code , 'WAD_ATTR' , ' ' , 'WAD_OBJATTR' , ' ' , src_constant_value )) sourcevalue from oe_def_attr_condns_v d, oe_lookups l, oe_def_attr_rules_v k where d.database_object_name = k.database_object_name and d.attr_def_condition_id = k.attr_def_condition_id and d.condition_id = k.condition_id and d.attribute_code = k.attribute_code and k.src_type not in ('RELATED_RECORD','SAME_RECORD','PROFILE_OPTION') and l.lookup_type = 'DEFAULTING_SOURCE_TYPE' and (k.src_type = l.lookup_code or (k.src_type = k.attribute_code and l.lookup_code = 'CONSTANT')) &object_where &condition_where &attribute_where &seed_where UNION select d.database_object_display_name, d.attribute_display_name, d.precedence, d.display_name, d.system_flag, d.enabled_flag, k.sequence_no, l.meaning , a.object_name || '.' || a.name source, src_type, k.attribute_code, ONT_OEXDERUL_XMLP_PKG.sourcevalueformula(src_type, k.attribute_code, a.object_name || '.' || a.name) sourcevalue from oe_def_attr_condns_v d, oe_lookups l, oe_def_attr_rules_v k, ak_object_attributes_vl a where d.database_object_name = k.database_object_name and d.attr_def_condition_id = k.attr_def_condition_id and d.condition_id = k.condition_id and d.attribute_code = k.attribute_code and a.database_object_name (+) = k.src_database_object_name and a.attribute_code (+) = k.src_attribute_code and l.lookup_type = 'DEFAULTING_SOURCE_TYPE' and k.src_type = l.lookup_code and k.src_type = 'RELATED_RECORD' &object_where &condition_where &attribute_where &seed_where union select d.database_object_display_name, d.attribute_display_name, d.precedence, d.display_name, d.system_flag, d.enabled_flag, k.sequence_no, l.meaning , a.name source, src_type, k.attribute_code, ONT_OEXDERUL_XMLP_PKG.sourcevalueformula(src_type, k.attribute_code,a.name) sourcevalue from oe_def_attr_condns_v d, oe_lookups l, oe_def_attr_rules_v k, ak_object_attributes_vl a where d.database_object_name= k.database_object_name and d.attr_def_condition_id = k.attr_def_condition_id and d.condition_id = k.condition_id and d.attribute_code = k.attribute_code and a.database_object_name (+) = k.database_object_name and a.attribute_code (+) = k.src_attribute_code and l.lookup_type = 'DEFAULTING_SOURCE_TYPE' and k.src_type = l.lookup_code and k.src_type = 'SAME_RECORD' &object_where &condition_where &attribute_where &seed_where union select d.database_object_display_name, d.attribute_display_name, d.precedence, d.display_name, d.system_flag, d.enabled_flag, k.sequence_no, l.meaning , a.user_profile_option_name source, src_type, k.attribute_code, ONT_OEXDERUL_XMLP_PKG.sourcevalueformula(src_type, k.attribute_code,a.user_profile_option_name) sourcevalue from oe_def_attr_condns_v d, oe_lookups l, oe_def_attr_rules_v k, fnd_profile_options_vl a where d.database_object_name = k.database_object_name and d.attr_def_condition_id = k.attr_def_condition_id and d.condition_id = k.condition_id and a.profile_option_name (+) = k.src_profile_option and l.lookup_type = 'DEFAULTING_SOURCE_TYPE' and k.src_type = l.lookup_code and k.src_type = 'PROFILE_OPTION' &object_where &condition_where &attribute_where &seed_where ONT OEXDERUL_XML AR ONT تقرير قائمة القواعد الافتراضية Application: إدارة الطلبات Source: تقرير قائمة القواعد الافتراضية (XML) Short Name: OEXDERUL_XML DB package: ONT_OEXDERUL_XMLP_PKG D ONT Liste Standardregeln Application: Order Management Source: Liste Standardregeln (XML) Short Name: OEXDERUL_XML DB package: ONT_OEXDERUL_XMLP_PKG F ONT Etat Règles d'affectation de valeur par défaut sous forme de liste Application: Order Management Source: Etat Règles d'affectation de valeur par défaut sous forme de liste (XML) Short Name: OEXDERUL_XML DB package: ONT_OEXDERUL_XMLP_PKG US ONT Defaulting Rules Listing Application: Order Management Source: Defaulting Rules Listing Report (XML) Short Name: OEXDERUL_XML DB package: ONT_OEXDERUL_XMLP_PKG ZHS ONT 默认规则列表报表 Application: 订单管理 Source: 默认规则列表报表 (XML) Short Name: OEXDERUL_XML DB package: ONT_OEXDERUL_XMLP_PKG BI Publisher &attribute_where &condition_where &object_where &seed_where :attribute_where :condition_where :lp_attribute :lp_object :object_where :p_attribute :p_conc_request_id :p_condition :p_object :p_order_by :p_seeded :p_sob_id :rp_attribute :rp_condition :rp_data_found :rp_object :rp_report_name :rp_seeded :rp_sub_title :seed_where 1 10 :p_object LOV Oracle ONT_SRS_DEF_RULES_OBJECTS Y select database_object_name id, name value, null description from oe_def_ak_obj_ext_v order by value,description AR الوحدة D Objekt F Objet US Object ZHS 对象 2 20 :p_condition LOV Oracle ONT_SRS_DEF_RULES_CONDNS Y select condition_id id, display_name value, null description from oe_def_conditions_vl where database_object_name=:$flex$.ont_srs_def_rules_objects order by value,description AR الشرط D Bedingung US Condition ZHS 条件 3 30 :p_attribute LOV Oracle ONT_SRS_DEF_RULES_ATTRIBUTES Y select attribute_code id, attribute_display_name value, null description from oe_def_ak_attr_ext_v where database_object_name=:$flex$.ont_srs_def_rules_objects and defaulting_enabled_flag='Y' order by value,description AR السمة D Attribut F Attribut US Attribute ZHS 属性 4 40 :p_seeded LOV Oracle OM: Yes or No Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning AR الأصلي D Vordefiniert F Prédéfini US Seeded ZHS 系统初始