CS_DOC_SETPO_VW (SQL View)	Index Back
Active Adhoc id prompt Prompt for Adhoc ID doc_find page (uses edittable) .. active docs only

CS_DOC_SETPO_VW

Prompt for Adhoc ID doc_find page (uses edittable) .. active docs only

SELECT A.SETID FROM PS_CS_DOC_PO_KEYS A , PS_CS_DOC_HDR B WHERE A.CS_DOC_ID = B.CS_DOC_ID AND B.CLOSE_FLAG <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID