OM Line Defaulting Rules Query

select
d.database_object_display_name  OBJECT,
d.attribute_display_name ATTRIBUTE,
d.precedence,
d.display_name CONDITION,
d.system_flag SEEDED,
d.enabled_flag ENABLED,
k.sequence_no,
l.meaning SOURCE_TYPE,
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) DEFAULT_SOURCE_VALUE
--src_type,
--k.attribute_code
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'))
and d.database_object_name = 'OE_AK_ORDER_LINES_V'
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
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'
and d.database_object_name = 'OE_AK_ORDER_LINES_V'
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
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'
and d.database_object_name = 'OE_AK_ORDER_LINES_V'
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
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'
and d.database_object_name = 'OE_AK_ORDER_LINES_V'