REQ_SE_LINE_VN2 (SQL View)	Index Back
REQ Line PTSF view

REQ_SE_LINE_VN2

(SQL View)

REQ Line PTSF view

SELECT A.BUSINESS_UNIT , A.REQ_ID , B.VENDOR_SETID , B.VENDOR_ID , (CASE WHEN E.VENDOR_ID IS NOT NULL THEN E.SES_VN_ATTR_L_DTTM ELSE A.LAST_DTTM_UPDATE END) FROM PS_REQ_HDR A ,(PS_REQ_LINE B LEFT OUTER JOIN PS_VENDOR E ON E.SETID = B.VENDOR_SETID AND E.VENDOR_ID = B.VENDOR_ID) WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = 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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

4 SUPPLIER_ID Character(10) VARCHAR2(10) NOT NULL Supplier ID

5 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	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
4	SUPPLIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Supplier ID
5	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.