WM_PMLP_SCHD_LV

(SQL View)
 Index Back

PM Loop Schedule View

PM Loop Schedule View used as search record. If loop is inactive, PM Schedule defined for the loop will not be listed. Prompt for asset subtype and manufacturer is just for convenience since these attributes on one set of loop can come from multiple sets.

SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , LA.LANGUAGE_CD , LB.DESCR50 , LA.DESCR100 FROM PS_WM_PM_SCHD A , PS_SET_CNTRL_REC C , PS_WM_PM_SCHD_LG LA , PS_WM_PM_LOOP_LG LB WHERE A.MAINT_LOOP_ID <> ' ' AND A.MAINT_LOOP_ID = LB.MAINT_LOOP_ID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.REC_GROUP_ID = 'WM_01' AND C.RECNAME = 'WM_PM_LOOP_HDR' AND C.SETID = LB.SETID AND LA.LANGUAGE_CD = LB.LANGUAGE_CD AND LA.BUSINESS_UNIT = A.BUSINESS_UNIT AND LA.PM_SCHD_ID = A.PM_SCHD_ID

  • Related Language Record for WM_PMLP_SCHD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_WM_NONVW

    2 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID

    Default Value: NEXT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description