FIN_MBL_TYPLVW2(SQL View) |
Index Back |
|---|---|
Mobile Approval Trans/TypesMobile Approval Trans/Types |
| SELECT A.FIN_MBL_ITEM_TYPE , C.LANGUAGE_CD , CASE WHEN A.HMAP_ITEM_GRP_ID = ' ' THEN C.FIN_MBL_ITEM_NAME ELSE B.DESCR END , C.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 FROM PS_FIN_MBL_TYPE A LEFT OUTER JOIN PS_HMAP_ITMGRP_LNG B ON B.HMAP_ITEM_GRP_ID = A.HMAP_ITEM_GRP_ID , PS_FIN_MBL_TYPE_LN C WHERE C.FIN_MBL_ITEM_TYPE = A.FIN_MBL_ITEM_TYPE |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | FIN_MBL_ITEM_NAME | Character(30) | VARCHAR2(30) NOT NULL | Transaction or Type name |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | FIN_MBL_ITEM_HNDLR | Character(254) | VARCHAR2(254) NOT NULL | Transaction or Type data handler app class |
| 6 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: EOAWPACKAGE_VW |
| 7 | FIN_MBL_IMG_LARGE | Character(254) | VARCHAR2(254) NOT NULL | Large image |
| 8 | FIN_MBL_IMG_MEDIUM | Character(254) | VARCHAR2(254) NOT NULL | Medium size image |
| 9 | FIN_MBL_IMG_SMALL | Character(254) | VARCHAR2(254) NOT NULL | Small image |
| 10 | FIN_MBL_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 11 | FIN_MBL_SHOW_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Included/shown indicator
Y/N Table Edit Default Value: N |
| 12 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: EOAW_TXN |
| 13 | HMAP_INCL_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Include in Fluid
Y/N Table Edit Default Value: N |
| 14 | HMAP_MASS_APPR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Mass Approvals
Y/N Table Edit Default Value: N |
| 15 | HMAP_ITEM_GRP_ID | Character(8) | VARCHAR2(8) NOT NULL |
Transaction or Type ID
Prompt Table: HMAP_ITEM_GROUP |
| 16 | EOAW_APPROVE | Character(1) | VARCHAR2(1) NOT NULL |
Approve
Y/N Table Edit Default Value: Y |
| 17 | EOAW_DENY | Character(1) | VARCHAR2(1) NOT NULL |
Deny
Y/N Table Edit Default Value: N |
| 18 | EOAW_PUSHBACK | Character(1) | VARCHAR2(1) NOT NULL |
Pushback
Y/N Table Edit Default Value: N |
| 19 | EOAW_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Hold
Y/N Table Edit Default Value: N |
| 20 | EOAW_REQUESTINFO | Character(1) | VARCHAR2(1) NOT NULL |
Request Information
Y/N Table Edit Default Value: N |