Scripts to get the statistics based on order type:<\/p>\n
— Number of orders taken in each order type per month<\/p>\n
–Number of lines shipped in each order type per month Scripts to get the statistics based on order type: — Number of orders taken in each order type per month select b.name,b.description,to_char(ordered_date,’Mon’) Month, count(0) NoOfOrders from oe_order_headers_all a, oe_transaction_types_tl b where 1=1 and a.order_type_id = b.transaction_type_id and ordered_Date between ’01-SEP-2009′ and ’01-OCT-2009′ and org_id = 1 group by b.name, b.description,to_char(ordered_date,’Mon’) order by to_char(ordered_date,’Mon’) –Number of […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1841","post","type-post","status-publish","format-standard","hentry","category-scripts"],"yoast_head":"\n
\nselect b.name,b.description,to_char(ordered_date,'Mon') Month, count(0) NoOfOrders
\nfrom oe_order_headers_all a,
\n oe_transaction_types_tl b
\nwhere 1=1
\nand a.order_type_id = b.transaction_type_id
\nand ordered_Date between '01-SEP-2009' and '01-OCT-2009'
\nand org_id = 1
\ngroup by b.name, b.description,to_char(ordered_date,'Mon')
\norder by to_char(ordered_date,'Mon')<\/code><\/p>\n
\nselect b.name,b.description,to_char(schedule_ship_date,'Mon') Month, count(0) NoOfOrders
\nfrom oe_order_lines_all a,
\n oe_transaction_types_tl b,
\n oe_order_headers_all c
\nwhere 1=1
\nand c.order_type_id = b.transaction_type_id
\nand a.header_id = c.header_id
\nand a.org_id = c.org_id
\nand schedule_ship_date between '01-SEP-2009' and sysdate
\nand a.org_id = 1
\ngroup by b.name, b.description,to_char(schedule_ship_date,'Mon')<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"