RS_SO_STAT_VW1

(SQL View)

SELECT DISTINCT(A.SO_ID) ,A.BUSINESS_UNIT ,A.LASTUPDDTTM FROM PS_RS_SO_STATUS A ,PS_RS_SO_STATUS B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.SO_ID=B.SO_ID AND A.SO_STATUS NOT IN ('C','X') GROUP BY A.BUSINESS_UNIT,A.SO_ID,A.LASTUPDDTTM HAVING A.LASTUPDDTTM =MAX(B.LASTUPDDTTM )

Audit Record: RS_SO_AUDIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

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

3 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.