ONT-ECC Command Center

Description
Run ONT-ECC Command Center and other Oracle EBS reports with Blitz Report™ on our demo environment
select * from OE_ECC_ORDER_LINES_V
where 1=1
Parameter Name SQL text Validation
Customer Name
upper(customer) like upper(:customer_name)
LOV
Order Type
order_type=:order_type
LOV
Order Status
flow_status_code=xxen_util.lookup_code(:header_status,'FLOW_STATUS',660)
LOV
Operating Unit
operating_unit=:operating_unit
LOV