SCP_SECATTL1_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , B.ATTACHSYSFILENAME , B.ATTACH_DESCR , B.ATTACHUSERFILE , A.SEND_TO_VENDOR , A.BID_FACTOR_NBR , A.LINE_NBR , D.DESCR254_MIXED , A.BIDDER_ID , A.BIDDER_SETID , E.OPRID FROM PS_AUC_ATTCH A , PS_PV_ATTACHMENTS B , PS_AUC_LINE D , PS_VNDR_USER_VW_FL E WHERE A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION AND A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.AUC_ID = D.AUC_ID AND A.LINE_NBR = D.LINE_NBR AND A.BIDDER_SETID = E.SETID AND A.BIDDER_ID = E.VENDOR_ID AND A.SEND_TO_VENDOR = 'Y' AND A.BIDDER_TYPE = 'V' AND A.LINE_NBR <> 0 AND A.BID_FACTOR_NBR = 0 AND (A.AUC_EVENT_PDF_FLG = 'Y' OR A.AUC_EVENT_XML_FLG = 'Y') AND A.BIDDER_ID <> ' ' AND A.BIDDER_ID <> 'PUBLIC_AUC' UNION SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , B.ATTACHSYSFILENAME , B.ATTACH_DESCR , B.ATTACHUSERFILE , A.SEND_TO_VENDOR , A.BID_FACTOR_NBR , A.LINE_NBR , D.DESCR254_MIXED , A.BIDDER_ID , A.BIDDER_SETID , E.OPRID FROM PS_AUC_ATTCH A , PS_PV_ATTACHMENTS B , PS_AUC_LINE D , PSOPRALIAS E WHERE A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION AND A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.AUC_ID = D.AUC_ID AND A.LINE_NBR = D.LINE_NBR AND A.BIDDER_SETID = E.SETID AND A.BIDDER_ID = E.BIDDER_ID AND E.OPRALIASTYPE = 'BID' AND A.BIDDER_TYPE = 'B' AND A.SEND_TO_VENDOR = 'Y' AND A.LINE_NBR <> 0 AND A.BID_FACTOR_NBR = 0 AND (A.AUC_EVENT_PDF_FLG = 'Y' OR A.AUC_EVENT_XML_FLG = 'Y') AND A.BIDDER_ID <> ' ' AND A.BIDDER_ID <> 'PUBLIC_AUC' UNION SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , B.ATTACHSYSFILENAME , B.ATTACH_DESCR , B.ATTACHUSERFILE , A.SEND_TO_VENDOR , A.BID_FACTOR_NBR , A.LINE_NBR , D.DESCR254_MIXED , E.OPRALIASVALUE , A.BIDDER_SETID , E.OPRID FROM PS_AUC_ATTCH A , PS_PV_ATTACHMENTS B , PS_AUC_LINE D , PSOPRALIAS E WHERE A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION AND A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.AUC_ID = D.AUC_ID AND A.LINE_NBR = D.LINE_NBR AND A.BIDDER_SETID = E.SETID AND A.BIDDER_ID = E.OPRALIASVALUE AND E.OPRALIASTYPE = 'CST' AND A.BIDDER_TYPE = 'C' AND A.SEND_TO_VENDOR = 'Y' AND A.LINE_NBR <> 0 AND A.BID_FACTOR_NBR = 0 AND (A.AUC_EVENT_PDF_FLG = 'Y' OR A.AUC_EVENT_XML_FLG = 'Y') AND A.BIDDER_ID <> ' ' AND A.BIDDER_ID <> 'PUBLIC_AUC' UNION SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , B.ATTACHSYSFILENAME , B.ATTACH_DESCR , B.ATTACHUSERFILE , A.SEND_TO_VENDOR , A.BID_FACTOR_NBR , A.LINE_NBR , D.DESCR254_MIXED , A.BIDDER_ID , A.BIDDER_SETID , ' ' FROM PS_AUC_ATTCH A , PS_PV_ATTACHMENTS B , PS_AUC_LINE D WHERE A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION AND A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.AUC_ID = D.AUC_ID AND A.LINE_NBR = D.LINE_NBR AND A.SEND_TO_VENDOR = 'Y' AND A.LINE_NBR <> 0 AND A.BID_FACTOR_NBR = 0 AND A.BIDDER_ID = ' ' AND A.AUC_EVENT_PDF_FLG = 'N' AND A.AUC_EVENT_XML_FLG = 'N' UNION SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , B.ATTACHSYSFILENAME , B.ATTACH_DESCR , B.ATTACHUSERFILE , A.SEND_TO_VENDOR , A.BID_FACTOR_NBR , A.LINE_NBR , D.DESCR254_MIXED , A.BIDDER_ID , A.BIDDER_SETID , ' ' FROM PS_AUC_ATTCH A , PS_PV_ATTACHMENTS B , PS_AUC_LINE D WHERE A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION AND A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.AUC_ID = D.AUC_ID AND A.LINE_NBR = D.LINE_NBR AND A.SEND_TO_VENDOR = 'Y' AND A.LINE_NBR <> 0 AND ((A.BIDDER_TYPE = 'P' AND A.BIDDER_ID = 'PUBLIC_AUC' AND (A.AUC_EVENT_PDF_FLG = 'Y' OR A.AUC_EVENT_XML_FLG = 'Y')) OR (A.BIDDER_TYPE = ' ' AND (A.AUC_EVENT_PDF_FLG = 'N' AND A.AUC_EVENT_XML_FLG = 'N')))

# 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 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
6 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
7 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
8 SEND_TO_VENDOR Character(1) VARCHAR2(1) NOT NULL Send to Vendor
9 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
11 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
12 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
13 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).