RB_TD_ACTION_VW

(SQL View)
 Index Back

View on Actions

This is a view on RB_TD_ACT_DFN and RB_TD_TRANS_ACT. This view has been created to optimize the call to the database in the application class/method RB_TD_360:TreeConfiguration. GetTransaction().

SELECT a.ACTION_DFN_ID , a.TRANSACTION_NAME , b.DESCR , a.STATUS , b.SETCNTRLVALUE , a.DISABLE_INACTIVEBO , a.SEQNUM ,a.DEFAULT_FLG FROM PS_RB_TD_TRANS_ACT a , PS_RB_TD_ACT_DFN b WHERE a.ACTION_DFN_ID = b.ACTION_DFN_ID

  • Related Language Record: RB_TD_ACTIONLVW

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

    Prompt Table: RB_TD_ACT_DFN

    2 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    6 DISABLE_INACTIVEBO Character(1) VARCHAR2(1) NOT NULL This flag is used to identify if the Action is to be disabled for Inactive Business Objects.
    7 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    8 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag