FIN_MBL_TYPELVW

(SQL View)
 Index Back

Mobile Approval Trans/Types

Mobile Approval Trans/Types related language record.

SELECT A.FIN_MBL_ITEM_TYPE , C.LANGUAGE_CD , CASE A.HMAP_ITEM_GRP_ID WHEN ' ' THEN C.FIN_MBL_ITEM_NAME ELSE B.DESCR END , C.FIN_MBL_ITEM_NAME 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

  • Related Language Record for FIN_MBL_TYPE_VW

    • # 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