PV_REQ_CNRT_SRH

(SQL View)
 Index Back

Contract Search for PO's


SELECT DISTINCT C.ITM_SETID , C.INV_ITEM_ID , A.VENDOR_SETID , A.VENDOR_ID , A.SETID , A.CNTRCT_ID , PO.BUSINESS_UNIT , PO.PO_ID , B.VENDOR_NAME_SHORT , A.CNTRCT_STATUS , A.DESCR , C.AMT_ONLY_FLG FROM PS_VENDOR B , PS_CNTRCT_LINE C , PS_CNTRCT_HDR A , PS_CNTRCT_BPO_XREF PO WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND ((A.CNTRCT_TYPE = 'PO') OR (A.CNTRCT_TYPE = 'GN')) AND A.CNTRCT_STATUS = 'A' AND A.VCHR_SRC = 'CNTR' AND A.SETID = C.SETID AND A.CNTRCT_ID = C.CNTRCT_ID AND C.AMT_ONLY_FLG = 'N' AND A.SETID = PO.SETID (+) AND A.CNTRCT_ID = PO.CNTRCT_ID (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
9 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

Prompt Table: VENDOR_PO_NM_VW

10 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

11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes