WM_PM_ARMJT_LVW

(SQL View)
 Index Back

PM Asset Job Templates RL View

PM Asset Job Templates View -- related language view

SELECT A.SETID , A.BUSINESS_UNIT_AM , A.ASSET_ID , B.WO_TEMPLATE_ID , C.LANGUAGE_CD , C.DESCR50 FROM PS_WM_PM_ARM_VW A , PS_WM_WO_JTMPL_VW B , PS_WM_WO_JTMPL_LVW C WHERE B.SETID = A.SETID AND (B.ASSET_TYPE IN (A.ASSET_TYPE, ' ')) AND (B.ASSET_SUBTYPE IN (A.ASSET_SUBTYPE, ' ')) AND (B.MFG_ID IN (A.MFG_ID, ' ')) AND (B.MODEL IN (A.MODEL, ' ')) AND C.SETID = B.SETID AND C.WO_TEMPLATE_ID = B.WO_TEMPLATE_ID

  • Related Language Record for WM_PM_ARM_JT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Prompt Table: SP_BU_AM_NONVW

    3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    4 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50