Operation Details
Description: Count duplicate Supplier Returns for Supplier Return Header.
Sterotype: ns
SQL
SELECT
  COUNT(*)
INTO
  :returnHeaderCount 
FROM
  SupplierReturnHeader 
WHERE SupplierReturnHeader.supplierConcernRoleID = :supplierConcernRoleID 
  AND SupplierReturnHeader.recordStatus = :recordStatus 
  AND SupplierReturnHeader.docReferenceNumber = :docReferenceNumber 
  AND SupplierReturnHeader.numberOfItems = :numberOfLineItems 
  AND SupplierReturnHeader.totalAmount = :totalAmount