RB_TD_ACT_OBVW

(SQL View)
 Index Back

View on Actions

This is a view on security view for RB_TD_ACTION_VW.

SELECT a.ACTION_DFN_ID , a.TRANSACTION_NAME , b.DESCR , a.STATUS , b.SETCNTRLVALUE , a.DISABLE_INACTIVEBO , a.SEQNUM ,a.DEFAULT_FLG ,o.OPRID FROM PS_RB_TD_TRANS_ACT a , PS_RB_TD_ACT_DFN b , PS_SEC_BU_OPR o WHERE a.ACTION_DFN_ID = b.ACTION_DFN_ID AND (EXISTS ( SELECT 'x' FROM PS_SET_CNTRL_TBL c , PS_SEC_BU_OPR o WHERE b.SETCNTRLVALUE = o.BUSINESS_UNIT AND o.BUSINESS_UNIT = c.SETCNTRLVALUE) OR SETCNTRLVALUE = ' ')

  • Related Language Record: RB_TD_ACT_LOBVW

    • # 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
    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).