SCP_SEC_AUC_VW

(SQL View)
 Index Back

Secure Bidder Pagelet View

Secure Portal Bidder Pagelet View

SELECT B.BUSINESS_UNIT , B.AUC_ID , B.AUC_ROUND , B.AUC_VERSION , B.AUC_STATUS , B.AUC_STATUS , B.AUC_FORMAT , B.AUC_TYPE , B.BLIND_FLG , B.AUC_NAME , B.TIMEZONE , B.AUC_DTTM_START , B.AUC_DTTM_FINISH , B.AUC_DTTM_PREVIEW , B.BUYER_ID FROM PS_AUC_HDR B WHERE B.AUC_STATUS IN( 'A', 'P', 'T' ,'U' ,'F', 'I', 'Q') AND B.AUC_TYPE IN ('E','S') AND B.AUC_FORMAT IN ('F','R','I') AND B.AUC_DTTM_FINISH >= %CurrentDateTimeIn AND B.AUC_DTTM_PREVIEW <= %CurrentDateTimeIn

# 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_STATUS_TXT Character(30) VARCHAR2(30) NOT NULL Status
6 AUC_BID_STATUS_JS Long Character CLOB Bid Status
7 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
8 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
9 BLIND_FLG Character(1) VARCHAR2(1) NOT NULL Sealed Event
10 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
11 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
12 AUC_DTTM_START DateTime(26) TIMESTAMP Date Time Start
13 AUC_DTTM_FINISH DateTime(26) TIMESTAMP Date Time Finish
14 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
15 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer