RB_TD_ACTIONLVW

(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 , l.LANGUAGE_CD , a.TRANSACTION_NAME , l.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 , PS_RB_TD_ACT_DRLR l WHERE a.ACTION_DFN_ID = b.ACTION_DFN_ID AND b.ACTION_DFN_ID = l.ACTION_DFN_ID

  • Related Language Record for RB_TD_ACTION_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    6 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    7 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.
    8 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    9 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag