RA_MC_USAGE_VW

(SQL View)
 Index Back

Marketing Center Usage

View of marketing centers being used throughout various CRM components. Added WHERE RA_MKT_CENTER <> ' ' on 03/2009

SELECT DISTINCT RA_MKT_CENTER FROM PS_RA_MKTCTR_AUD WHERE RA_MKT_CENTER <> ' ' UNION SELECT DISTINCT RA_MKT_CENTER FROM PS_RY_MKTCTR_DLG WHERE RA_MKT_CENTER <> ' ' UNION SELECT DISTINCT RA_MKT_CENTER FROM PS_RA_MKTCTR_CMP WHERE RA_MKT_CENTER <> ' ' UNION SELECT DISTINCT RA_MKT_CENTER FROM PS_RY_MKTCTR_DOC WHERE RA_MKT_CENTER <> ' ' UNION SELECT DISTINCT RA_MKT_CENTER FROM PS_RA_MKTCTR_PRF WHERE RA_MKT_CENTER <> ' ' UNION SELECT DISTINCT RA_MKT_CENTER FROM PS_RY_MKTCTR_TMPL WHERE RA_MKT_CENTER <> ' ' UNION SELECT DISTINCT RA_MKT_CENTER FROM PS_RAE_MKTCTR_EVT WHERE RA_MKT_CENTER <> ' ' UNION SELECT DISTINCT RA_MKT_CENTER FROM PS_RA_ACAD_CAR_MC WHERE RA_MKT_CENTER <> ' ' UNION SELECT DISTINCT RA_MKT_CENTER FROM PS_RA_ACAD_PGM_MC WHERE RA_MKT_CENTER <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RA_MKT_CENTER Character(10) VARCHAR2(10) NOT NULL Marketing Center code