RB_TSK_TXID_LVW

(SQL View)
 Index Back

RLR for RB_TSK_TXID_VW

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

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') AND TM.MARKET = 'GBL'

  • Related Language Record for RB_TSK_TXID_VW

    • # 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