REQ_SE_LINE_VND (SQL View)	Index Back
REQ Line PTSF view

REQ_SE_LINE_VND

(SQL View)

REQ Line PTSF view

SELECT B.BUSINESS_UNIT , B.REQ_ID , MAX(E.SES_VN_ATTR_L_DTTM) FROM PS_REQ_LINE B , PS_VENDOR E WHERE E.SETID = B.VENDOR_SETID AND E.VENDOR_ID = B.VENDOR_ID GROUP BY B.BUSINESS_UNIT, B.REQ_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
Default Value: NEXT

3 SES_VN_ATTR_L_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTime specific for vendor attributes such as vendor name, vendor location, vendor phone and vendor contact.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID Default Value: NEXT
3	SES_VN_ATTR_L_DTTM	DateTime(26)	TIMESTAMP	PTSF Last Modified DateTime specific for vendor attributes such as vendor name, vendor location, vendor phone and vendor contact.