RA_MC_REASG_LVW

(SQL View)
 Index Back

Marketing Center Information

Used at Reassign Marketing Center Page, Markting Center field prompt view

SELECT MKT.RA_MKT_CENTER ,MKTLANG.LANGUAGE_CD , MKT.DESCR50 , INS.DESCR FROM PS_RA_UD_MKTCENTER MKT , PS_INSTITUTION_TBL INS , PS_RA_UD_MKTCTR_LG MKTLANG WHERE MKT.RA_HE_CENTER_TYPE <> 'A' AND MKT.STATUS ='A' AND MKT.CS_INSTITUTION = INS.INSTITUTION AND MKT.RA_MKT_CENTER=MKTLANG.RA_MKT_CENTER UNION SELECT MKT1.RA_MKT_CENTER ,MKTLANG1.LANGUAGE_CD , MKT1.DESCR50 , ' ' FROM PS_RA_UD_MKTCENTER MKT1 , PS_RA_UD_MKTCTR_LG MKTLANG1 WHERE MKT1.RA_HE_CENTER_TYPE <> 'A' AND MKT1.STATUS ='A' AND MKT1.CS_INSTITUTION =' ' AND MKT1.RA_MKT_CENTER=MKTLANG1.RA_MKT_CENTER

  • Related Language Record for RA_MC_REASG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_MKT_CENTER Character(10) VARCHAR2(10) NOT NULL Marketing Center code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description