ONT-ECC Command Center

Description

Columns: Ecc Spec Id, Ecc Last Update Date, Order Number, Line Number, Line Id, Header Id, Product, Line Quantity, Unit Selling Price, Order Uom ... Columns: Ecc Spec Id, Ecc Last Update Date, Order Number, Line Number, Line Id, Header Id, Product, Line Quantity, Unit Selling Price, Order Uom, Product Description, Line Type, Price List, Price List Id, Order Date, Ship From Org Id, Warehouse, Source Type, Shipment Method, Carrier, Shipment Priority, Shipping Instructions, Packing Instructions, Freight Terms, Salesperson, Customer, Customer Number, Ship To Customer Name, Ship To Customer Number, Ship To Contact, Ship To Contact Id, Ship To Address, Ship To Org Id, Bill To Customer Name, Bill To Customer Number, Bill To Contact, Bill To Contact Id, Bill To Address, Bill To Org Id, Expected Delay, Request Date, Request Date Type, Schedule Ship Date, Actual Shipment Date, Schedule Arrival Date, Actual Arrival Date, Latest Acceptable Date, Fulfillment Date, Flow Status Code, Line Status, Item Type Code, Org Id, Operating Unit, Line Category Code, Fulfilled Flag, Line Tran Amount, Open Flag, Transaction Currency, Txn Currency Code, Func Currency Code, Func Currency, Line Amount, Ship To Site, Ship To Location, Ship To State, Ship To Country, Bill To Site, Bill To City, Bill To State, Bill To Country, Line Last Update Date, Primary Uom, Inventory Item Id, Sales Channel, Order Type, Status, Shipped Quantity, Fulfilled Quantity, Invoiced Quantity, Schedule Status, Promise Date, Customer Po, Payment Term, Agreement Name, Sales Agreement Number, Sales Agreement Line Number, Subinventory, Pick Status, Transactional Order Total, Order Total, Reserved Quantity, Party Id, Predicted Return Reason Code, Anomalies, Line Hold Name, Header Hold Name, Total Hold Name, Alert Flag, Alert Count, Alert Text, Graph Alert Name, Delay Flag, Delay Count, Conversion Rate, Conversion Type Code, Reserved Qty, Booked Flag, Order Alert Count, Alert Type, Hdr Alert Count, Language Code, Alert Type Code, Table Alert Flag, Hdr Last Update Date, On Alert, Is Open, Is Booked, Line Quantity 1, Shipped Quantity 1, Currency, Csr User Id, Csr User Name, Line Type Last Update Date, Order Booked Date, Order Creation Date, Shipment Number, Option Number, Component Number, Service Number, Ship Set Name, Arrival Set Name

Copy

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

Download

Related Blitz Reports

ECC Procurement, Requisitions ECC Discrete Manufacturing, Work Orders RLM Release Management Exceptions ONT Orders on Credit Check Hold WSH Pick Slip INV Intercompany Invoice Reconciliation ECC Discrete Manufacturing, Work Order Delays ECC Project Manufacturing, Exceptions and Overdues, SQL4 ECC Project Manufacturing, Exceptions and Overdues, SQL3

Blitz Report In Action

Blitz Report™

Blitz Report™ provides multiple benefits:

Perfectly formatted Excel reports
Create new or ad-hoc reports in minutes
User configurable reports
Includes seeded reports for all core areas
Toolkits for tuning, management and support
Data governance and audit tracking
Central report repository & version control
Imports BI-Publisher and Discoverer reports
EBS forms interface for user adoption

Find out more

Features

Download

FAQ