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