aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_find_target_folio_item
Description
Find target folio item in folio pattern using specfied department id
Parameters
Name
Type
Mode
folio_id
integer
IN
dept_id
integer
IN
Definition
SELECT fi.item_id FROM folio_details fd LEFT JOIN folio_items fi ON fi.folio_id = fd.folio_id and fi.folio_seq = fd.folio_seq WHERE fd.folio_id = $1 AND fd.dept_id = $2 AND NOT fi.closed LIMIT 1