LM_EQP_SRCH_LVW

(SQL View)
 Index Back

Equipment Language Search

Equipment Language Search View

SELECT C.OPRID ,A.LM_EQP_ID ,A.LANGUAGE_CD ,D.LM_EQP_TYPE ,A.LM_EQP ,A.LM_EQP_SHORT FROM PS_LM_EQP_TBL_LANG A , PS_LM_EQP_LE B , PS_LM_OPRID_LE_VW C , PS_LM_EQPTYPE_LANG D , PS_LM_EQP_TBL E WHERE A.LM_EQP_ID = B.LM_EQP_ID AND B.LM_LE_ID = C.LM_LE_ID AND A.LM_EQP_ID = E.LM_EQP_ID AND E.LM_EQP_TYPE_ID = D.LM_EQP_TYPE_ID AND A.LANGUAGE_CD = D.LANGUAGE_CD

  • Related Language Record for LM_EQP_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_EQP_ID Number(10,0) DECIMAL(10) NOT NULL Equipment ID

    Prompt Table: LM_EQP_LE_VW

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_EQP_TYPE Character(50) VARCHAR2(50) NOT NULL Equipment Type Description
    5 LM_EQP Character(50) VARCHAR2(50) NOT NULL Equipment Description
    6 LM_EQP_SHORT Character(10) VARCHAR2(10) NOT NULL Equipment Short Description