WM_PM_SCHD_LV

(SQL View)
 Index Back

PM Schedule View

PM Schedule View Used as search record

SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , LA.LANGUAGE_CD , LA.DESCR100 FROM PS_WM_PM_SCHD A , PS_WM_PM_SCHD_LG LA WHERE A.BUSINESS_UNIT_AM <> ' ' AND A.ASSET_ID <> ' ' AND LA.BUSINESS_UNIT = A.BUSINESS_UNIT AND LA.PM_SCHD_ID = A.PM_SCHD_ID

  • Related Language Record for WM_PM_SCHD_VW WM_PM_SCHLK1_VW WM_PM_SCHLK2_VW WM_PM_SCHLNK_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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description