PTPN_TBE_CFG_1(SQL View) |
Index Back |
---|---|
TBE Configuration View |
SELECT DISTINCT E.PTPN_CATEGORY_NAME AS PTPN_CATEGORY_NAME , E.OBJECTOWNERID AS OBJECTOWNERID , B.OBJNAME AS ptpn_busprocname , B.compname AS ptpn_activityname , R.eventname AS ptpn_eventname1 , R.ROUTENAME AS ptpn_worklistname FROM PSACTIVITYDEFN A , psbusprocitem B , PSEVENTROUTE R , PS_PTPN_PDT_OWNERV E WHERE A.ACTIVITYNAME = B.COMPNAME AND R.ACTIVITYNAME = B.COMPNAME AND B.OBJTYPE=0 AND (E.objectownerid = A.objectownerid) AND R.ROUTETYPE=3 AND A.ACTVALID != 9 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(50) | VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table: PSPTPN_CAT_TBL |
|
2 | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier | |
3 | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name | |
4 | Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity | |
5 | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow | |
6 | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |