LM_SRCHDMTHDLVW

(SQL View)
 Index Back

Search: View CI Delivery Methd

Search view for delivery method. This is the related language table.

SELECT C1.LM_CI_ID , A1.LM_ACT_ID , DMTYP1.LM_DMTHD_TYPE_ID , DMTYPLNG1.LANGUAGE_CD , DMTYPLNG1.LM_DM_LONG_NM FROM PS_LM_CI_TBL C1 , PS_LM_DMTHD_ALL_VW DMALL1 , PS_LM_DMTH_TYP_TBL DMTYP1 , PS_LM_DMTH_TYP_LNG DMTYPLNG1 , PS_LM_ACT A1 WHERE %Sql(LM_SRCHDMTHD_SQL,C1,DMALL1,DMTYP1,A1) AND DMTYP1.LM_DMTHD_TYPE_ID = DMTYPLNG1.LM_DMTHD_TYPE_ID

  • Related Language Record for LM_SRCHDMTHD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    3 LM_DMTHD_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method Type ID - This is a unique identifier for each delivery method type
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type