ONT-ECC Command Center

Description
Columns: Ecc Spec Id, Ecc Last Update Date, Ord Num, Line Number, Line Id, Header Id, Product, Line Quantity, Unit Selling Price, Order Uom ...
select * from OE_ECC_ORDER_LINES_V
where 1=1
Parameter Name SQL text Validation
Customer Name
upper(customer) like upper(:customer_name)
LOV
Operating Unit
operating_unit=:operating_unit
LOV
Order Type
order_type=:order_type
LOV
Order Status
flow_status_code=xxen_util.lookup_code(:header_status,'FLOW_STATUS',660)
LOV