RB_TD_ACT_LOBVW

(SQL View)
 Index Back

View on Actions

This is a view on security view for RB_TD_ACTION_VW.

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 , o.OPRID FROM PS_RB_TD_TRANS_ACT a , PS_RB_TD_ACT_DFN b , PS_SEC_BU_OPR o , PS_RB_TD_ACT_DRLR L WHERE a.ACTION_DFN_ID = b.ACTION_DFN_ID AND b.ACTION_DFN_ID = L.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 for RB_TD_ACT_OBVW

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