WM_MOD_PMSCH_VW

(SQL View)
 Index Back

Mfg Model PM Sched Use View

Note: this is a component ("sub-view") of main view WM_MFMOD_USE_VW

SELECT A.SETID , A.MFG_ID , A.MODEL , ( SELECT 'Y' FROM PS_INSTALLATION WHERE EXISTS ( SELECT 'X' FROM PS_WM_PM PM WHERE A.SETID = ( SELECT S1.SETID FROM PS_SET_CNTRL_REC S1 WHERE S1.SETCNTRLVALUE = PM.BUSINESS_UNIT AND S1.REC_GROUP_ID = 'FS_18' AND S1.RECNAME = 'MFG_MODEL') AND PM.MFG_ID = A.MFG_ID AND PM.MODEL = A.MODEL) OR EXISTS ( SELECT 'X' FROM PS_WM_PM_LOOP_EFF LE WHERE LE.SETID = ( SELECT S2.SETID FROM PS_SET_CNTRL_REC S2 WHERE S2.SETCNTRLVALUE = A.SETID AND S2.REC_GROUP_ID = 'WM_01' AND S2.RECNAME = 'WM_PM_LOOP_HDR') AND LE.MFG_ID = A.MFG_ID AND LE.MODEL = A.MODEL AND LE.EFF_STATUS = 'A')) AS IN_USE_FLAG FROM PS_MFG_MODEL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
3 MODEL Character(30) VARCHAR2(30) NOT NULL Model
4 IN_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Row in use flag