EOCM_TRDPRTNR_L

(SQL View)
 Index Back

List of TPM partner (lang rela

This view gets a list of TPM partners who are registered as partners and whose services have been approved VR on June 2013, Bug 14806591 -Created as language related. VR on July 2013. SETID removed from USE tab

SELECT DISTINCT C.SETID , A.EOTP_PARTNERID ,A.LANGUAGE_CD , A.EOTP_COMPNAME FROM PS_EOTP_PARTNER_L 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 for EOCM_TRDPARTNER

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description