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 |