WORKLISTNAMECS_CW_DWLSN_VW2(SQL View) |
Index Back |
|---|---|
Signature Related WL - POSCMT003 - for SCMT Docs -- Signature Related Worklists -- Purchase orders |
| SELECT DISTINCT a.worklistname , a.eoawdescr , %Substring(a.eoawdescr ,17 ,5) , %Substring(a.eoawdescr ,32 ,10) FROM PS_EOAW_WL A , PSWORKLIST B WHERE A.EOAWPRCS_ID = 'Document' AND %Substring(A.EOAWDESCR, 17, 14) = 'PO Contract ID' AND b.busprocname = a.busprocname AND b.activityname = a.activityname AND b.eventname = a.eventname AND b.worklistname = a.worklistname AND b.instanceid = a.instanceid AND b.inststatus IN (0,1) AND b.oprid = %OperatorId |
| # | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |