WORKLISTNAMECS_CW_POWKLSTVW(SQL View) |
Index Back |
|---|---|
PO worklistssSCMT003 - view for where exists on PO worklists for Approval Routing Transaction Approved Transaction Denied |
| SELECT DISTINCT a.worklistname , a.eoawdescr , d.cs_doc_id , c.business_unit , c.po_id , B.oprid FROM PS_EOAW_WL A , PSWORKLIST B , PS_PO_AW c , PS_CS_DOC_PO_KEYS D WHERE A.EOAWPRCS_ID = 'PurchaseOrder' 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 c.eoawthread_id = a.eoawthread_id AND c.eoawprcs_id = a.eoawprcs_id AND c.eoawdefn_id = a.eoawdefn_id |
| # | 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). |