Date Initials Issue Description ========================================== 06/2007 CEL F-AHAYT-748L7 New view to be used to select reqs tied to Purchasing source transactions

CS_LIST_REQ2_VW

(SQL View)

Index Back

SELECT DISTINCT A.CS_DOC_ID , B.BUSINESS_UNIT , B.PO_ID , A.BUSINESS_UNIT_REQ , A.REQ_ID FROM PS_CS_DOC_HDR A , PS_PO_LINE_DISTRIB 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

4 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit

5 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	BUSINESS_UNIT_REQ	Character(5)	VARCHAR2(5) NOT NULL	Requesting Business Unit
5	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID