aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_target_folio_seq
Parameters
Name
Type
Mode
folio_id
integer
IN
dept_id
integer
IN
force_first_folio
boolean
IN (DEFAULT false)
Definition
SELECT coalesce( (SELECT fd.folio_seq FROM folio_details fd WHERE fd.folio_id = $1 AND fd.dept_id = $2), CASE WHEN force_first_folio THEN (SELECT min(fi.folio_seq) FROM folio_items fi WHERE fi.folio_id = $1 AND NOT fi.closed) ELSE null END )