Operation Details
Description: Read resource transfer related sanction list that make up each sanction member record.
Sterotype: nsmulti
SQL 
SELECT
  ISPAUTORESOURCETRANSFER.itemType,
  ISPTRANSFERSANCTIONLINK.durationOfDisqualification,
  ISPTRANSFERSANCTIONLINK.disqualificationStartDate,
  ISPTRANSFERSANCTIONLINK.transferSanctionID,
  ISPTRANSFERSANCTIONLINK.linkedTransferType
INTO
  :itemType,
  :durationOfDisqualification,
  :disqualificationStartDate,
  :transferSanctionID,
  :linkedTransferType 
FROM
  ISPAUTORESOURCETRANSFER,
  ISPTRANSFERSANCTIONLINK,
  SANCTION 
WHERE ISPAUTORESOURCETRANSFER.autoResourceTransferID = ISPTRANSFERSANCTIONLINK.linkedID 
  AND ISPTRANSFERSANCTIONLINK.sanctionID = :sanctionID 

UNION
  
SELECT
  RESOURCETRANSFER.itemType,
  ISPTRANSFERSANCTIONLINK.durationOfDisqualification,
  ISPTRANSFERSANCTIONLINK.disqualificationStartDate,
  ISPTRANSFERSANCTIONLINK.transferSanctionID,
  ISPTRANSFERSANCTIONLINK.linkedTransferType 
FROM
  RESOURCETRANSFER,
  ISPTRANSFERSANCTIONLINK,
  SANCTION 
WHERE RESOURCETRANSFER.evidenceID = ISPTRANSFERSANCTIONLINK.linkedID 
  AND ISPTRANSFERSANCTIONLINK.sanctionID = :sanctionID