Reports2017-11-18T12:27:27+00:00

ONT Defaulting Rules Listing

Description
Categories: BI Publisher, Sales
Application: Order Management
Source: Defaulting Rules Listing Report (XML)
Short Name: OEXDERUL_XML
DB package: ONT_OEXDERUL_XMLP_PKG
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
Parameter Name SQL text Validation
Seeded
 
LOV Oracle
Attribute
 
LOV Oracle
Condition
 
LOV Oracle
Object
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept