Operation Details |
Description: | Reads all Products |
Sterotype: | nsmulti |
SQL |
SELECT productID, name, typeCode, statusCode, startDate, endDate, benefitInd, adminCategory, versionNo INTO :productID, :name, :typeCode, :statusCode, :startDate, :endDate, :benefitInd, :adminCategory, :versionNo FROM Product WHERE (adminCategory = :adminCategory OR adminCategory IS NULL) ORDER BY name |