SETIDEOCM_ACCESS_IDOPRIDEOCM_TP_USER_VW(SQL View) |
Index Back |
|---|---|
Trading Partner UsersList of users for a trading partner subscribing to the catalog management service |
| SELECT DISTINCT A.SETID , A.EOTP_PARTNERID , A.OPRID , D.OPRDEFNDESC FROM PS_EOTP_PARTUSRSVC A , PS_EOCM_CATALOG_TP B , PS_EOCM_CATALOG C , PSOPRDEFN D , PS_EOTP_SVCPROC E WHERE A.SETID = C.SETID AND B.SETID = C.SETID AND A.SETID = B.SETID AND A.EOTP_PARTNERID = B.EOCM_ACCESS_ID AND B.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND E.SETID = A.SETID AND E.EOTP_SERVICEID = A.EOTP_SERVICEID AND (E.EOTP_PROCESS = 'P' OR E.EOTP_PROCESS = 'R') AND D.OPRID = A.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EOCM_ACCESS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Field for storing the Partner ID |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |