Open order lines

➜ Back to Library
Description
select
count(*) count,
oola.line_category_code,
oola.open_flag,
nvl2(oola.schedule_ship_date,'not null',null) schedule_ship_date,
oola.flow_status_code
from
oe_order_lines_all oola
group by
oola.line_category_code,
oola.open_flag,
nvl2(oola.schedule_ship_date,'not null',null),
oola.flow_status_code
order by
oola.line_category_code,
oola.open_flag desc,
count(*) desc
Download
Related Blitz Reports
XXAMZ OTIF Delivered Orders(XXONT1253) INV Intercompany Invoice Reconciliation AUR:CST COGS Revenue Matching PPF_WP3_OM_DETAILS Yanmar - Discount on order lines check COPY OF: TB GL Account Analysis (Drilldown)v3 GL Account Distribution Analysis TB GL Account Analysis (Drilldown)v3 ONT Orders on Credit Check Hold QP Pricing Agreements
Blitz Report™