RB_TSK_TXN_SRVW

(SQL View)
 Index Back

Transactions for Task.

This view lists the Transaction types that are linked to Tasks.

SELECT DISTINCT A.RB_TRANSACTION_ID , B.TRANSACTION_TITLE FROM PS_RB_TSK_TXN A , PS_RB_TXN_MKT B WHERE A.RB_TRANSACTION_ID = B.RB_TRANSACTION_ID AND A.TXN_MARKET = B.MARKET

  • Related Language Record: RB_TSK_TXN_LGVW

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

    Prompt Table: RB_TXN_DEFN

    2 TRANSACTION_TITLE Character(30) VARCHAR2(30) NOT NULL Transaction Title