SQL:ProductDeliveryPlanItemLink.searchCaseIDAndVersionNoByPlannedItemID

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: ProductDeliveryPlanItemLink.searchCaseIDAndVersionNoByPlannedItemID

Operation Details

Description:	Lists case ID and version number for all cases associated with Planned Item.
Sterotype:	nsmulti

SQL

SELECT
  CaseHeader.caseID,
  CaseHeader.versionNo
INTO
  :caseID,
  :versionNo 
FROM
  ProductDeliveryPlanItemLink,
  CaseHeader 
WHERE ProductDeliveryPlanItemLink.plannedItemID = :plannedItemID 
  AND CaseHeader.caseID = ProductDeliveryPlanItemLink.caseID