ONT-ECC Command Center

➜ Back to Library
Description
select * from OE_ECC_ORDER_LINES_V
where 1=1
Parameter NameSQL textValidation
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
Download
Related Blitz Reports
ECC Procurement, Requisitions ECC Project Manufacturing, Sales Orders ECC Project Manufacturing Genealogy & Trace, Sales Orders ECC Project Manufacturing Genealogy & Trace, Project Locators ECC Project Manufacturing, Exceptions and Overdues, SQL4 ECC Project Manufacturing, Exceptions and Overdues, SQL3 ECC Discrete Manufacturing, Work Orders ECC Discrete Manufacturing, Work Order Delays ECC Order Management, Order Lines (1)
Blitz Report™