RA_ODERWAVE_LVW

(SQL View)
 Index Back

Link Order customer to Wave

View to link order customer to wave

SELECT DISTINCT A.BO_ID ,G.LANGUAGE_CD ,B.RA_WAVE_NAME ,C.RA_OFFER_NAME ,F.XLATSHORTNAME ,G.DESCR FROM PS_RA_LIST_REC A , PS_RA_CMPGN_WAVE B , PS_RA_OFFER C , PSXLATITEMLANG F , PS_RA_OFFPRDPRC_L G , PS_RA_UD_CHNL_TYPE H WHERE A.RA_LIST_ID = B.RA_LIST_ID AND A.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = B.BUSINESS_UNIT AND RECNAME = 'RA_LIST_REC') AND A.DELETED_FLG = 'N' AND C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = B.BUSINESS_UNIT AND RECNAME = 'RA_OFFER') AND B.RA_OFFER_ID = C.RA_OFFER_ID AND B.RA_SCRIPT_ID_INBN <> 0 AND B.RA_ACTIVITY_CD = H.RA_ACTIVITY_CD AND B.RA_CHANNEL_TYPE = H.RA_CHANNEL_TYPE AND H.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = B.BUSINESS_UNIT AND RECNAME = 'RA_UD_CHNL_TYPE') AND H.RA_CHNL_EXECUTION= '030' AND F.FIELDNAME = 'RA_PRIORITY' AND F.FIELDVALUE = B.RA_PRIORITY AND F.EFFDT = ( SELECT MAX(E.EFFDT) FROM PSXLATITEM E WHERE E.FIELDNAME = F.FIELDNAME AND E.FIELDVALUE = F.FIELDVALUE AND E.EFFDT <= %CurrentDateIn AND E.EFF_STATUS = 'A') AND G.SETID = C.SETID AND G.RA_OFFER_ID = C.RA_OFFER_ID AND G.PRICE_SET_ID = C.PRICE_SET_ID

  • Related Language Record for RA_ORDERWAVE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RA_WAVE_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.
    4 RA_OFFER_NAME Character(50) VARCHAR2(50) NOT NULL Marketing Offer Name
    5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description