OE_ORDER_LINES_ALL FLOW_STATUS_CODE

超越 Oracle EBS
超越是要分析 
不是苦幹

SELECT ol.flow_status_code,COUNT(*)
--'AWAITING_SHIPPING'
  FROM oe_order_lines_all ol
-- WHERE ol.line_id = sn.line_id
-- AND ol.flow_status_code = 'AWAITING_SHIPPING'
GROUP BY ol.flow_status_code
ORDER BY 2 DESC

CLOSED                     1021436
CANCELLED                  67021
AWAITING_SHIPPING          56451
AWAITING_RETURN            53960
ENTERED                    43400
PRE-BILLING_ACCEPTANCE     9507
POST-BILLING_ACCEPTANCE    5933
SUPPLY_ELIGIBLE            373
PO_OPEN                    160
SHIPPED                    76
BOOKED                     76
EXTERNAL_REQ_OPEN          44
REJECTED_PENDING_CANC      39
INVOICE_DELIVERY           7
INVOICE_HOLD               1