This report shows last days sale and purchase value of all units of the enterprise
What happens now?
Once you've decided on the report or view you'd like to buy, simply add it to your basket and proceed through the checkout. You will visit 2checkout.com who are our payment processor, and on successful payment you will return to our site and the code will be unlocked for you to use. There will be a direct link in the order confirmation screen, or you can view the code at any time in the future through your Account screen.
What am I buying?
There are a total of 42 lines of code in this product. Here is an example:
15. AND jispl.org_id = oeh.org_id
16. --and oeh.creation_date > sysdate-1
17. AND jispl.creation_date > SYSDATE - 1
18. AND oeh.cancelled_flag = 'N'
19. --and oeh.FLOW_STATUS_CODE='CLOSED'
20. AND jispl.order_header_id = oeh.header_id