Query to find Number of line processed in Order Management

Oracle Apps >Oracle SQL

Oracle  EBS R12 Purchasing, Inventory, Order Management Queries:

Following is the query:

SELECT COUNT (line_id) “Order Line Processed”
FROM oe_order_lines_all
WHERE creation_date BETWEEN TO_DATE (:Fdate, ‘DD/MM/YYYY’)
AND TO_DATE (:tdate, ‘DD/MM/YYYY’)
AND flow_status_code = ‘CLOSED’;