RB_TSK_TXID_VW

(SQL View)
 Index Back

Task Transaction ID view

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

SELECT T.RB_TRANSACTION_ID , TM.TRANSACTION_TITLE FROM PS_RB_TXN_DEFN T , PS_RB_TXN_MKT 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: RB_TSK_TXID_LVW

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