Operation Details
Description: <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-IE style="mso-ansi-language: EN-IE"><FONT size=3><FONT face="Times New Roman">Gets the Issue and Product Delivery cases associated with the Integrated Case and sees if any of them have active Appeals on them. If active Appeals are found&nbsp;they are added&nbsp;to the count that is returned.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></FONT></SPAN></P>
Sterotype: ns
SQL 
SELECT 
COUNT(*)

INTO
:numOfRecords

FROM 
AppealRelationship

WHERE 
AppealRelationship.recordStatus = :recordStatus AND
AppealRelationship.caseID IN (

SELECT
  CaseRelationship.relatedCaseID 
FROM
  CaseRelationship,
  CaseHeader 
WHERE CaseRelationship .caseID = :caseID AND
  CaseHeader.caseID = CaseRelationship .relatedCaseID AND
  CaseRelationship.statusCode = :recordStatus AND
  (
    CaseHeader.statusCode <> :closedCaseStatus AND 
    CaseHeader.statusCode <> :cancelledCaseStatus AND 
    CaseHeader.statusCode IS NOT NULL 
  )

UNION
  
SELECT
  CaseRelationship.caseID
FROM
  CaseRelationship,
  CaseHeader
WHERE CaseRelationship.relatedCaseID = :caseID AND 
  CaseHeader.caseID = CaseRelationship.caseID AND
  CaseRelationship.statusCode = :recordStatus AND
  (
    CaseHeader.statusCode <> :closedCaseStatus AND 
    CaseHeader.statusCode <> :cancelledCaseStatus AND 
    CaseHeader.statusCode IS NOT NULL 
  )
)