FIN_MBL_TYPE_VW

(SQL View)
 Index Back

Mobile Approval Trans/Types

Mobile Approval Trans/Types

SELECT A.FIN_MBL_ITEM_TYPE , CASE A.HMAP_ITEM_GRP_ID WHEN ' ' THEN A.FIN_MBL_ITEM_NAME ELSE B.DESCR END , A.FIN_MBL_ITEM_NAME , A.FIN_MBL_ITEM_HNDLR , A.PACKAGEROOT , A.FIN_MBL_IMG_LARGE , A.FIN_MBL_IMG_MEDIUM , A.FIN_MBL_IMG_SMALL , A.FIN_MBL_SEQNUM , A.FIN_MBL_SHOW_FLG , A.EOAWPRCS_ID , A.HMAP_INCL_APPR , A.HMAP_MASS_APPR_FLG , A.HMAP_ITEM_GRP_ID , A.EOAW_APPROVE , A.EOAW_DENY , A.EOAW_PUSHBACK , A.EOAW_HOLD , A.EOAW_REQUESTINFO , A.EOAW_REQCOMM_FLG , A.EOAW_SHOWTERM_FLG FROM PS_FIN_MBL_TYPE A LEFT OUTER JOIN PS_HMAP_ITEM_GROUP B ON B.HMAP_ITEM_GRP_ID = A.HMAP_ITEM_GRP_ID

  • Related Language Record: FIN_MBL_TYPELVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIN_MBL_ITEM_TYPE Character(8) VARCHAR2(8) NOT NULL Transaction or Type ID
    2 FIN_MBL_ITEM_NAME Character(30) VARCHAR2(30) NOT NULL Transaction or Type name
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 FIN_MBL_ITEM_HNDLR Character(254) VARCHAR2(254) NOT NULL Transaction or Type data handler app class
    5 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: EOAWPACKAGE_VW

    6 FIN_MBL_IMG_LARGE Character(254) VARCHAR2(254) NOT NULL Large image
    7 FIN_MBL_IMG_MEDIUM Character(254) VARCHAR2(254) NOT NULL Medium size image
    8 FIN_MBL_IMG_SMALL Character(254) VARCHAR2(254) NOT NULL Small image
    9 FIN_MBL_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence number
    10 FIN_MBL_SHOW_FLG Character(1) VARCHAR2(1) NOT NULL Included/shown indicator

    Y/N Table Edit

    Default Value: N

    11 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

    Prompt Table: EOAW_TXN

    12 HMAP_INCL_APPR Character(1) VARCHAR2(1) NOT NULL Include in Fluid

    Y/N Table Edit

    Default Value: N

    13 HMAP_MASS_APPR_FLG Character(1) VARCHAR2(1) NOT NULL Allow Mass Approvals

    Y/N Table Edit

    Default Value: N

    14 HMAP_ITEM_GRP_ID Character(8) VARCHAR2(8) NOT NULL Transaction or Type ID

    Prompt Table: HMAP_ITEM_GROUP

    15 EOAW_APPROVE Character(1) VARCHAR2(1) NOT NULL Approve

    Y/N Table Edit

    Default Value: Y

    16 EOAW_DENY Character(1) VARCHAR2(1) NOT NULL Deny

    Y/N Table Edit

    Default Value: N

    17 EOAW_PUSHBACK Character(1) VARCHAR2(1) NOT NULL Pushback

    Y/N Table Edit

    Default Value: N

    18 EOAW_HOLD Character(1) VARCHAR2(1) NOT NULL Hold

    Y/N Table Edit

    Default Value: N

    19 EOAW_REQUESTINFO Character(1) VARCHAR2(1) NOT NULL Request Information

    Y/N Table Edit

    Default Value: N

    20 EOAW_REQCOMM_FLG Character(1) VARCHAR2(1) NOT NULL Require Comments for fluid approval deny action
    21 EOAW_SHOWTERM_FLG Character(1) VARCHAR2(1) NOT NULL Show terminated transactions in fluid approval flag