CNT_SUPP_LOC_VW

(SQL View)
 Index Back

Supplier Locations View

11/15/2015 JOHAN PO0025 - Master contract fluid

SELECT C.SETID , C.CNTRCT_ID , C.VERSION_NBR , C.VNDR_LOC , A.DESCR , 'Y' , C.VNDR_LOC FROM PS_CNTRCT_RELTN C LEFT OUTER JOIN PS_CNT_SUPPLIER_VW A ON A.SETID = C.SETID AND A.CNTRCT_ID = C.CNTRCT_ID AND A.VERSION_NBR = C.VERSION_NBR AND A.VNDR_LOC = C.VNDR_LOC WHERE C.RELTN_TYPE = 'S' UNION SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , A.VNDR_LOC , A.DESCR , 'N' , A.VNDR_LOC FROM PS_CNT_SUPPLIER_VW A WHERE NOT EXISTS ( SELECT 'X' FROM PS_CNTRCT_RELTN C WHERE A.SETID = C.SETID AND A.CNTRCT_ID = C.CNTRCT_ID AND A.VERSION_NBR = C.VERSION_NBR AND C.RELTN_TYPE = 'S' AND A.VNDR_LOC = C.VNDR_LOC)

# 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 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: %EDITTABLE7

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 INCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL include flag

Y/N Table Edit

Default Value: N

7 SUPPLIER_LOC Character(10) VARCHAR2(10) NOT NULL Remit To