Database SQL Operation: SupplierReturnHeader.countDuplicateSupplierReturns
Description: | Count duplicate Supplier Returns for Supplier Return Header. |
Sterotype: | ns |
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
|