ONT Processing Constraints Listing

Description
Categories: BI Publisher, Sales
Application: Order Management
Source: Processing Constraints Listing Report (XML)
Short Name: OEXOEPCL_XML
DB package: ONT_OEXOEPCL_XMLP_PKG
SELECT c.constraint_id,
e.entity_display_name entity, 
c.column_display_name attribute,
l1.meaning opeartion,
l2.meaning user_action,
l4.meaning seeded,
cc.group_number,
l3.meaning scope,
cc.validation_entity_display_name val_entity,
cc.record_set_display_name record_set,
decode(cc.modifier_flag,'Y',Null,'        ') modifier,
cc.validation_tmplt_display_name val_template,
l5.meaning seeded_flag, 
	ONT_OEXOEPCL_XMLP_PKG.c_appl_toformula(:C_count_resp, c.constraint_id) C_APPL_TO
from oe_pc_constraints_v c,
oe_pc_entities_v e,
oe_pc_constraint_cnds_v cc,
oe_lookups l1,
oe_lookups l2,
oe_lookups l3, 
oe_lookups l4,
oe_lookups l5
where c.entity_id = e.entity_id(+) 
and l1.lookup_code(+) = c.constrained_operation 
and l1.lookup_type(+) = 'PC_OPERATION'
and l2.lookup_code(+) = c.on_operation_action
and l2.lookup_type(+) = 'PC_ON_OPERATION_ACTION'
and l4.lookup_code(+) = c.system_flag
and l4.lookup_type(+) = 'YES_NO'
and c.constraint_id = cc.constraint_id(+)
and l3.lookup_code(+) = cc.scope_op
and l3.lookup_type(+) = 'PC_SCOPE_OP'
and l5.lookup_code(+) = cc.system_flag
and l5.lookup_type(+) = 'YES_NO'
&lp_entity
&lp_attribute
&lp_operation
&lp_val_entity
&lp_record_set
&lp_val_template
&lp_seeded
ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,6 ASC , e.entity_display_name , nvl ( l1.meaning , 'A' ) , nvl ( c.column_display_name , 'A' ) , cc.group_number
Parameter Name SQL text Validation
Seeded
 
LOV Oracle
Validation Template
 
LOV Oracle
Record Set
 
LOV Oracle
Validation Entity
 
LOV Oracle
Operation
 
LOV Oracle
Attribute
 
LOV Oracle
Entity
 
LOV Oracle