WM_PM_ARM_JT_VW

(SQL View)
 Index Back

PM Asset Job Templates View

PM Asset Job Templates View -- selects Job Templates applicable to an asset; e.g., used as prompt table for PM Maint Loop Asset List "Override Job Template" field Note: level-2 view, joins level-1 views WM_PM_ARM_VW, WM_WO_JTMPL_VW

SELECT B.SETID , A.BUSINESS_UNIT AS BUSINESS_UNIT_AM , A.ASSET_ID , B.WO_TEMPLATE_ID , B.DESCR50 , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL , B.RESOLUTION_CD FROM PS_ASSET A , PS_WM_WO_JTMPL_VW B WHERE (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, ' '))

  • Related Language Record: WM_PM_ARMJT_LVW

    • # 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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other
    7 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    8 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    9 MODEL Character(30) VARCHAR2(30) NOT NULL Model
    10 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code