WM_MFMOD_USE_VW

(SQL View)
 Index Back

Mfg Model In-Use View


SELECT A.SETID , A.MFG_ID , A.MODEL , COALESCE(WT.IN_USE_FLAG , PM.IN_USE_FLAG , PR.IN_USE_FLAG , TM.IN_USE_FLAG , IP.IN_USE_FLAG , 'N') FROM PS_MFG_MODEL A LEFT OUTER JOIN PS_WM_MOD_WOTLS_VW WT ON WT.SETID = A.SETID AND WT.MFG_ID = A.MFG_ID AND WT.MODEL = A.MODEL LEFT OUTER JOIN PS_WM_MOD_PMSCH_VW PM ON PM.SETID = A.SETID AND PM.MFG_ID = A.MFG_ID AND PM.MODEL = A.MODEL LEFT OUTER JOIN PS_WM_MOD_PRBLM_VW PR ON PR.SETID = A.SETID AND PR.MFG_ID = A.MFG_ID AND PR.MODEL = A.MODEL LEFT OUTER JOIN PS_WM_MOD_TMPLT_VW TM ON TM.SETID = A.SETID AND TM.MFG_ID = A.MFG_ID AND TM.MODEL = A.MODEL LEFT OUTER JOIN PS_WM_MOD_INSPL_VW IP ON IP.SETID = A.SETID AND IP.MFG_ID = A.MFG_ID AND IP.MODEL = A.MODEL

# 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

Y/N Table Edit