CS_CW_POWRKLST

(SQL View)
 Index Back

all PO worklists

SCMT003 All PO Worklists for Contract Workbench

SELECT a.worklistname , A.EOAWDESCR , a.cs_doc_id , a.business_unit , a.po_id , a.oprid FROM PS_CS_CW_POWKLSTVW A UNION SELECT b.worklistname , B.EOAWDESCR , b.cs_doc_id , b.cs_setid_var , b.cs_cntrct_var , b.oprid FROM PS_CS_CW_DWLST_VW1 B WHERE B.CS_SOURCE_TRANS = '03'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
2 EOAWDESCR Character(254) VARCHAR2(254) NOT NULL Descr
3 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).