EOCM_TRDPARTNER

(SQL View)
 Index Back

List of TPM partner

This view gets a list of TPM partners who are registered as partners and whose services have been approved VR on July 2013, Bug 14806591 - Include Language Related record on properties.

SELECT DISTINCT C.SETID , A.EOTP_PARTNERID , A.EOTP_COMPNAME FROM PS_EOTP_PARTNER A , PS_EOTP_PARTNRSVCS C , PS_EOTP_SVCPROC D WHERE C.EOTP_PARTNERID = A.EOTP_PARTNERID AND C.SETID = D.SETID AND C.EOTP_SERVICEID = D.EOTP_SERVICEID AND A.EOTP_PARTNERSTAT = 'R' AND C.EOTP_SVCSTATUS = 'A' AND (D.EOTP_PROCESS = 'P' OR D.EOTP_PROCESS = 'R')

  • Related Language Record: EOCM_TRDPRTNR_L

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description