RECV_CMMT_SVW

(SQL View)

SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , B.COMMENTS_2000 FROM PS_RECV_COMMENTS A , PS_COMMENTS_TBL B WHERE A.OPRID = B.OPRID AND A.COMMENT_ID = B.COMMENT_ID AND A.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR AND A.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

3 SES_PROC_CMMT Long Character CLOB Common Procurement Comment Field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
3	SES_PROC_CMMT	Long Character	CLOB	Common Procurement Comment Field