WM_PM_JTLOOP_VW

(SQL View)
 Index Back

PM Loop Schd Job Tmplt View

PM Loop Schedule Job Template View -- prompt view; used to search for active WO Job Template defns with effectivity less than or equal to current loop-type PM Sched effective record's effdt

SELECT DISTINCT B.SETID , A.MAINT_LOOP_ID , B.WO_TEMPLATE_ID , C.EFFDT , B.DESCR50 , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL , C.RESOLUTION_CD , C.ITM_SETID , C.CRAFT_SETID , C.DESCR254 FROM PS_WM_PM_LOOP_EFF A , PS_WM_WO_TMPLT_HDR B , PS_WM_WO_JTMPL_EFF C WHERE A.EFF_STATUS = 'A' AND B.WO_TEMPLATE_TYPE = '2' 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 AND C.EFF_STATUS = 'A'

  • Related Language Record: WM_PM_JTLOOP_LV

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID
    3 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    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: WM_MANUFACTURER

    9 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: WM_WO_MFGMOD_VW

    10 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code

    Prompt Table: WM_RESOLUTN_VW

    11 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    12 CRAFT_SETID Character(5) VARCHAR2(5) NOT NULL Foreign key SetID to RS_CRAFT_DETAIL table
    13 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254