CS_LIST_REQS_VW

(SQL View)
Index Back

SELECT DISTINCT A.CS_DOC_ID , B.SETID , B.CNTRCT_ID , A.BUSINESS_UNIT_REQ , A.REQ_ID FROM PS_CS_DOC_HDR A , PS_CNTRCT_RFQ_XREF B WHERE A.BUSINESS_UNIT_REQ = B.BUSINESS_UNIT_REQ AND A.REQ_ID = B.REQ_ID AND A.REQ_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
4 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
5 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID