CS_REQ_CNT_SRCH

(SQL View)
 Index Back

Contract Search for PO's

General Contracts defined for syndication are not available for sourcing in the parent system.

SELECT DISTINCT A.VENDOR_SETID , A.VENDOR_ID , A.SETID , A.CNTRCT_ID , B.VENDOR_NAME_SHORT , A.CNTRCT_STATUS , A.DESCR , A.CNTRCT_BEGIN_DT FROM PS_CNTRCT_HDR A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.CNTRCT_CF_LOCK = 'N' AND (A.CNTRCT_EXPIRE_DT IS NULL OR (A.CNTRCT_EXPIRE_DT IS NOT NULL AND A.CNTRCT_EXPIRE_DT >= %CurrentDateIn)) AND B.VNDR_STATUS_PO = 'Y' AND ((A.CNTRCT_TYPE = 'PO') OR (A.CNTRCT_TYPE = 'GN' AND NOT EXISTS( SELECT 'X' FROM %Table(CS_CNTRCT_HD_SN) C WHERE A.SETID = C.SETID AND A.CNTRCT_ID = C.CNTRCT_ID))) AND A.CNTRCT_STATUS = 'A' AND A.VCHR_SRC = 'CNTR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

Prompt Table: VENDOR_PO_NM_VW

6 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled

Default Value: O

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date