PO_SSRFQLN_ATTC (SQL View)	Index Back
SS eRFQ Response. Used to extract comments from the RFQ being responded to. Found in PO_SSRFQ_LINES page. 09/21/2009 SCC 1868771000 Fix attachments

PO_SSRFQLN_ATTC

(SQL View)

SS eRFQ Response.

Used to extract comments from the RFQ being responded to. Found in PO_SSRFQ_LINES page. 09/21/2009 SCC 1868771000 Fix attachments

SELECT BUSINESS_UNIT , RFQ_ID , LINE_NBR , FILENAME , FILE_EXTENSION , ' ' , SCM_ATTACH_ID , ATT_VERSION FROM PS_RFQ_COMMENTS WHERE PUBLIC_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name

5 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension

6 GET_ATTACHMENT Character(1) VARCHAR2(1) NOT NULL Get Attachment

7 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.

8 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RFQ_ID	Character(10)	VARCHAR2(10) NOT NULL	RFQ ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
5	FILE_EXTENSION	Character(4)	VARCHAR2(4) NOT NULL	File Extension
6	GET_ATTACHMENT	Character(1)	VARCHAR2(1) NOT NULL	Get Attachment
7	SCM_ATTACH_ID	Character(64)	VARCHAR2(64) NOT NULL	The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
8	ATT_VERSION	Number(3,0)	SMALLINT NOT NULL	The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.