WM_PM_SCHDT2_VW

(SQL View)
 Index Back

PM Schedule Detail View

Preventive Maintenance Schedule Detail View

SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , A.DESCR100 FROM PS_WM_PM_SCHD A , PS_WM_PM_SCHD_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PM_SCHD_ID = B.PM_SCHD_ID AND B.EFFDT = ( SELECT MAX( D.EFFDT ) FROM PS_WM_PM_SCHD_DTL D WHERE D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.PM_SCHD_ID = B.PM_SCHD_ID AND D.EFFDT <= %CurrentDateIn AND (D.EFF_STATUS = 'A' OR (D.EFF_STATUS <> 'A' AND D.WM_PM_APPR_STATUS <> 'A')))

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

Prompt Table: SP_BU_WM_NONVW

2 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID
3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description