ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  SQL Subqueries
Subject:   : Pending Delivery Note Details
Date:   2009-04-05 22:19:33
From:   shebus
Details of delivery note which are not invoiced.
Views used - VW_DELIVERY_ACTUAL, VW_SALES_INVOICE
The report should be grouped by SALEPOINT,DOC_CODE
Parameters of the report (SalePoint(T1), Customer(T2), From Date(D1) & To Date(D2))
If Customer Parameter is null then Show all.