CNTRCTLNMFGIDVW

(SQL View)
Index Back

Contract Line Manufacturers

Distinct Manufacturers on Contract Lines

SELECT DISTINCT L.SETID , L.CNTRCT_ID , L.VERSION_NBR , L.MFG_ID , M.DESCR60 FROM PS_CNTRCT_LINE L , PS_MANUFACTURER M , PS_SET_CNTRL_REC S WHERE L.SETID = M.SETID AND L.MFG_ID = M.MFG_ID AND L.MFG_ID <> ' ' AND M.SETID = S.SETID AND L.SETID = S.SETCNTRLVALUE AND S.RECNAME = 'MANUFACTURER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description