| Operation Details |  |
| Description: | Select a distinct set of case id's for the same runID. |
| Sterotype: | nsmulti |
| SQL | |
SELECT caseID INTO :recordID FROM PDMRunCaseControl, PDMRunCaseControlFailure WHERE runID = :runID AND status= :status AND PDMRunCaseControl.pdmRunCaseControlID = PDMRunCaseControlFailure.pdmRunCaseControlID AND PDMRunCaseControlFailure.typeCode = :failureTypeCode ORDER BY caseID ASC |