WM_MOD_PRBLM_VW

(SQL View)
 Index Back

Mfg Model PCR Defn 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_GROUP_ASSET GA WHERE GA.SETID = ( SELECT S1.SETID FROM PS_SET_CNTRL_REC S1 WHERE S1.SETCNTRLVALUE = A.SETID AND S1.REC_GROUP_ID = 'WM_01' AND S1.RECNAME = 'WM_GROUP_ASSET') AND GA.MFG_ID = A.MFG_ID AND GA.MODEL = A.MODEL) OR EXISTS ( SELECT 'X' FROM PS_WM_PROBLEM_TREE PT WHERE PT.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_PROBLEM_TREE') AND PT.MFG_ID = A.MFG_ID AND PT.MODEL = A.MODEL)) 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