LM_UI_DMTHF_LVW

(SQL View)
 Index Back

View of Deliv Meth TypeTable

View of Delivery Method Table LM_DMTH_TYP_TBL (Language View) for Fluid

SELECT LM_DMTHD_TYPE_ID , LANGUAGE_CD , LM_DM_LONG_NM FROM PS_LM_DMTH_TYP_LNG UNION SELECT 9999999999 , A.LANGUAGE_CD , A.MESSAGE_TEXT FROM PSMSGCATLANG A WHERE A.MESSAGE_SET_NBR = 18101 AND A.MESSAGE_NBR = 10 UNION SELECT 9999999998 , A.LANGUAGE_CD , A.MESSAGE_TEXT FROM PSMSGCATLANG A WHERE A.MESSAGE_SET_NBR = 18092 AND A.MESSAGE_NBR = 1084 UNION SELECT 9999999997 , A.LANGUAGE_CD , A.MESSAGE_TEXT FROM PSMSGCATLANG A WHERE A.MESSAGE_SET_NBR = 18099 AND A.MESSAGE_NBR = 203

  • Related Language Record for LM_UI_DMH_FL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_DMTHD_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type