WM_MOD_INSPL_VW

(SQL View)
 Index Back

Mfg Model Insp 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_INSTRMT_TYPE IT WHERE IT.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_INSTRMT_TYPE') AND IT.MFG_ID = A.MFG_ID AND IT.MODEL = A.MODEL) OR EXISTS ( SELECT 'X' FROM PS_WM_INSP_CLC_HDR CH WHERE CH.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_INSP_CLC_HDR') AND CH.MFG_ID = A.MFG_ID AND CH.MODEL = A.MODEL) OR EXISTS ( SELECT 'X' FROM PS_WM_INSP_MMT_HDR MH WHERE MH.SETID = ( SELECT S3.SETID FROM PS_SET_CNTRL_REC S3 WHERE S3.SETCNTRLVALUE = A.SETID AND S3.REC_GROUP_ID = 'WM_01' AND S3.RECNAME = 'WM_INSP_MMT_HDR') AND MH.MFG_ID = A.MFG_ID AND MH.MODEL = A.MODEL) OR EXISTS ( SELECT 'X' FROM PS_WM_INSP_OBS_HDR OH WHERE OH.SETID = ( SELECT S4.SETID FROM PS_SET_CNTRL_REC S4 WHERE S4.SETCNTRLVALUE = A.SETID AND S4.REC_GROUP_ID = 'WM_01' AND S4.RECNAME = 'WM_INSP_OBS_HDR') AND OH.MFG_ID = A.MFG_ID AND OH.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