ONT Processing Constraints Listing

Description
Categories: BI Publisher
Application: Order Management
Source: Processing Constraints Listing Report (XML)
Short Name: OEXOEPCL_XML
DB package: ONT_OEXOEPCL_XMLP_PKG
Run ONT Processing Constraints Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Entity
 
LOV Oracle
Attribute
 
LOV Oracle
Operation
 
LOV Oracle
Validation Entity
 
LOV Oracle
Record Set
 
LOV Oracle
Validation Template
 
LOV Oracle
Seeded
 
LOV Oracle
Blitz Report™