PV_VNDCNT_UPDTM

(SQL View)
 Index Back

Contract last updt datetime

Contract last updt datetime per vendor

SELECT VENDOR_SETID , VENDOR_ID ,%Dttm(MAX(CNTRCT_BEGIN_DT), %TIMEIN('00.00.00.000000')) FROM PS_PV_CNT_SRCH_VW WHERE CNTRCT_AUTO_DFLT = 'Y' AND CNTRCT_BEGIN_DT <= %DatePart(%CurrentDateIn) GROUP BY VENDOR_SETID, VENDOR_ID UNION SELECT VENDOR_SETID , VENDOR_ID ,%Dttm(MAX(CNTRCT_EXPIRE_DT) , %TIMEIN('23.59.59.000000')) FROM PS_PV_CNT_SRCH_VW WHERE CNTRCT_AUTO_DFLT = 'Y' AND CNTRCT_EXPIRE_DT < %DatePart(%CurrentDateIn) GROUP BY VENDOR_SETID, VENDOR_ID UNION SELECT VENDOR_SETID , VENDOR_ID ,MAX(LAST_DTTM_UPDATE) FROM PS_CNTRCT_HDR A WHERE CNTRCT_AUTO_DFLT = 'Y' GROUP BY VENDOR_SETID, VENDOR_ID UNION SELECT VENDOR_SETID , VENDOR_ID ,MAX(LAST_DTTM_UPDATE) FROM PS_CNTRCT_HDR_MFG A WHERE CNTRCT_AUTO_DFLT = 'Y' GROUP BY VENDOR_SETID, VENDOR_ID UNION SELECT SETID , VENDOR_ID , %DateTimeIn('1900-01-01-00.00.00.000000') FROM PS_VENDOR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 LASTSESUPD_DTTM DateTime(26) TIMESTAMP Last Update Datetime