SQL:CaseHeader.searchProductDeliveryEligibilityByStatus

Home
Application Views and Tabs
Database Tables
Pages
Domain Definitions
Code Tables
Message Files
Application Properties
Workflows
Rule Sets
Dynamic Evidence
IEG Scripts
Datastore Schemas
Page Flows

Database SQL Operation: CaseHeader.searchProductDeliveryEligibilityByStatus

Operation Details

Description:
Sterotype:	nsmulti

SQL

SELECT
  CaseHeader.caseID
INTO
  :recordID 
FROM
  CaseHeader,
  ProductDelivery 
WHERE CaseHeader.caseID = ProductDelivery.caseID 
  AND CaseHeader.statusCode = :statusCode