SETIDEOCM_CATALOG_IDEOCM_ACCESS_IDEOCM_PARTNER_VW(SQL View) |
Index Back |
|---|---|
Catalog Management Partner VWCatalog Management - List of partner based on setid and catalog id |
| SELECT DISTINCT A.SETID , A.EOCM_CATALOG_ID , A.EOCM_ACCESS_ID , B.EOTP_COMPNAME FROM %Table(EOCM_CATALOG_TP) A , %Table(EOTP_PARTNER) B WHERE B.EOTP_PARTNERID = A.EOCM_ACCESS_ID AND A.EOCM_ACTIVE_FLAG = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EOCM_CATALOG_ID |
Character(32) | VARCHAR2(32) NOT NULL | Catalog ID |
| 3 | EOCM_ACCESS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Field for storing the Partner ID |
| 4 | EOTP_COMPNAME | Character(30) | VARCHAR2(30) NOT NULL | Company Name |