AUC_COLLAB_CMT3 (SQL View)	Index Back
Comments\Attachments RFI desc Collaboration Change view for Sourcing Event comments and attachments RFI bid factor description.

AUC_COLLAB_CMT3

(SQL View)

Comments\Attachments RFI desc

Collaboration Change view for Sourcing Event comments and attachments RFI bid factor description.

SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BID_FACTOR_NBR , A.BID_FACTOR_CD FROM PS_AUC_COLLAB_LOG A , PS_AUC_HDR B WHERE (A.RECNAME = 'AUC_COMMENTS_BF' OR A.RECNAME = 'AUC_ATTCH_BF_VW') AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND (B.AUC_COLLAB_STATUS = 'A' OR (A.AUC_COLLAB_SEQNUM < B.AUC_COLLAB_SEQNUM AND B.AUC_COLLAB_STATUS = 'C'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

5 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number

6 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
3	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
4	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
5	BID_FACTOR_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Bid Factor Number
6	BID_FACTOR_CD	Character(18)	VARCHAR2(18) NOT NULL	Bid Factor Code