Advertisement
| 04.28.2008 at 07:57AM PDT, ID: 23358935 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: |
SELECT TOP 100 PERCENT dbo.p21_view_invoice_hdr.company_no, dbo.p21_view_oe_hdr.customer_id, dbo.p21_view_oe_line.order_no,
dbo.p21_view_oe_line.item_id, dbo.p21_inventory_usage_view.number_of_orders, dbo.p21_inventory_usage_view.number_of_hits,
dbo.p21_inventory_usage_view.year_for_period, dbo.p21_inventory_usage_view.period,
CASE Service_Level WHEN dbo.p21_inventory_usage_view.number_of_hits > 0 THEN ((dbo.p21_inventory_usage_view.number_of_hits / dbo.p21_inventory_usage_view.number_of_orders)
* 100) ELSE 0
FROM dbo.p21_inventory_usage_view INNER JOIN
dbo.p21_view_oe_line ON dbo.p21_inventory_usage_view.item_id = dbo.p21_view_oe_line.item_id INNER JOIN
dbo.p21_view_oe_hdr ON dbo.p21_view_oe_line.order_no = dbo.p21_view_oe_hdr.order_no INNER JOIN
dbo.p21_view_invoice_hdr ON dbo.p21_view_oe_hdr.order_no = dbo.p21_view_invoice_hdr.order_no AND
dbo.p21_inventory_usage_view.year_for_period = dbo.p21_view_invoice_hdr.year_for_period AND
dbo.p21_inventory_usage_view.period = dbo.p21_view_invoice_hdr.period AND
dbo.p21_inventory_usage_view.company_id = dbo.p21_view_invoice_hdr.company_no
GROUP BY dbo.p21_view_oe_hdr.customer_id, dbo.p21_view_oe_line.order_no, dbo.p21_view_oe_line.item_id,
dbo.p21_inventory_usage_view.number_of_orders, dbo.p21_inventory_usage_view.number_of_hits, dbo.p21_inventory_usage_view.year_for_period,
dbo.p21_inventory_usage_view.period, dbo.p21_view_invoice_hdr.company_no
HAVING (dbo.p21_view_oe_hdr.customer_id = 4632) AND (dbo.p21_view_invoice_hdr.company_no = '01') AND
(dbo.p21_inventory_usage_view.year_for_period = 2008)
ORDER BY dbo.p21_view_oe_line.order_no, dbo.p21_view_oe_line.item_id
|
Advertisement
