RD_CR_TX_LVW

(SQL View)
 Index Back

RLR for RD_CALLRPT_TX_V

Related Language View of Transaction (Component Navigation) IDs that can be linked to a Call Report

SELECT T.RB_TRANSACTION_ID , TM.LANGUAGE_CD , TM.TRANSACTION_TITLE FROM PS_RB_TXN_DEFN T , PS_RB_TXN_MKT_LNG TM WHERE T.RB_TRANSACTION_ID = TM.RB_TRANSACTION_ID AND T.RB_TRANSACTION_ID IN ('LEAD', 'OPPRT', 'REFERRAL', 'COMPANY', 'PARTNER') AND TM.MARKET = 'GBL'

  • Related Language Record for RD_CALLRPT_TX_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RB_TRANSACTION_ID Character(25) VARCHAR2(25) NOT NULL Transaction ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 TRANSACTION_TITLE Character(30) VARCHAR2(30) NOT NULL Transaction Title