EOCF_BNDACT_LVW

(SQL View)
 Index Back

view of Bundle Action Types

view of action Types in an Action bundle

SELECT A.EOCF_ACTION_TYP_ID , B.LANGUAGE_CD , B.EOCF_ACT_TYP_NAME FROM PS_EOCF_ACTN_TYPE A , PS_EOCF_ACTTYP_LNG B WHERE A.EOCF_ACTION_TYP_ID = B.EOCF_ACTION_TYP_ID AND NOT EXISTS ( SELECT B.EOCF_ACTION_TYP_ID FROM PS_EOCF_ACT_BUNDLE B WHERE A.EOCF_ACTION_TYP_ID = B.EOCF_ACTION_TYP_ID) AND A.EOCF_IS_CMBIN_FLAG = 'Y'

  • Related Language Record for EOCF_BND_ACT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_ACTION_TYP_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier pointing to a discreet action type configuration
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EOCF_ACT_TYP_NAME Character(30) VARCHAR2(30) NOT NULL user-defined name to identify the characteristics of a particular action