RESP_CNTR_LN_VW

(SQL View)
 Index Back

SELECT RLN.BUSINESS_UNIT ,RLN.AUC_ID ,RLN.AUC_ROUND ,RLN.AUC_VERSION ,RLN.BIDNUM ,RLN.LINE_NBR ,RLN.BIDDER_SETID ,RLN.BIDDER_ID ,RLN.BIDDER_TYPE ,RLN.BIDDER_LOC ,RLN.DESCR254_MIXED ,AHD.AUC_FORMAT ,AHD.AUC_TYPE ,AHD.AUC_NAME ,AHD.AUC_STATUS ,AHD.AUC_DTTM_PREVIEW ,AHD.AUC_DTTM_START ,AHD.AUC_DTTM_FINISH FROM PS_RESP_LN RLN ,PS_RESP_LN RL2 , PS_AUC_HDR AHD WHERE RLN.BUSINESS_UNIT = AHD.BUSINESS_UNIT AND RLN.AUC_ID = AHD.AUC_ID AND RLN.AUC_ROUND = AHD.AUC_ROUND AND RLN.AUC_VERSION = AHD.AUC_VERSION AND RLN.BUSINESS_UNIT = RL2.BUSINESS_UNIT AND RLN.AUC_ID = RL2.AUC_ID AND RLN.AUC_ROUND = RL2.AUC_ROUND AND RLN.AUC_VERSION = RL2.AUC_VERSION AND RLN.BIDNUM = RL2.BIDNUM AND RLN.LINE_NBR = RL2.LINE_NBR AND RLN.BIDDER_SETID = RL2.BIDDER_SETID AND RLN.BIDDER_ID = RL2.BIDDER_ID AND RLN.BIDDER_TYPE = RL2.BIDDER_TYPE AND RLN.BIDDER_LOC = RL2.BIDDER_LOC AND ( EXISTS ( SELECT 'X' FROM PS_AUC_AWARD_HDR X1 ,PS_AUC_LINE X2 WHERE X1.BUSINESS_UNIT = X2.BUSINESS_UNIT AND X1.AUC_ID = X2.AUC_ID AND X1.AUC_ROUND = X2.AUC_ROUND AND X1.AUC_VERSION = X2.AUC_VERSION AND X1.BUSINESS_UNIT = RLN.BUSINESS_UNIT AND X1.AUC_ID= RLN.AUC_ID AND X1.AUC_ROUND = RLN.AUC_ROUND AND X1.AUC_VERSION = RLN.AUC_VERSION AND X2.LINE_NBR = RLN.LINE_NBR AND X1.BIDNUM = RLN.BIDNUM AND X1.BIDDER_SETID = RLN.BIDDER_SETID AND X1.BIDDER_ID = RLN.BIDDER_ID AND X1.BIDDER_TYPE = RLN.BIDDER_TYPE AND X1.BIDDER_LOC = RLN.BIDDER_LOC AND X1.AUC_BID_AWARD = 'C' ) OR ( EXISTS ( SELECT 'X' FROM PS_AUC_AWARD_LN X3 WHERE X3.BUSINESS_UNIT = RL2.BUSINESS_UNIT AND X3.AUC_ID= RL2.AUC_ID AND X3.AUC_ROUND = RL2.AUC_ROUND AND X3.AUC_VERSION = RL2.AUC_VERSION AND X3.LINE_NBR = RL2.LINE_NBR AND X3.BIDNUM = RL2.BIDNUM AND X3.BIDDER_SETID = RL2.BIDDER_SETID AND X3.BIDDER_ID = RL2.BIDDER_ID AND X3.BIDDER_TYPE = RL2.BIDDER_TYPE AND X3.BIDDER_LOC = RL2.BIDDER_LOC AND X3.AUC_BID_AWARD = '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 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
8 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
9 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
10 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
11 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
12 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
13 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
14 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
15 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
A=Awarded
C=Collaborating Event
D=Collaborating Bid Analysis
E=Evaluating
F=RFI Reviewed
I=Pending RFI Review
N=Not Awarded
O=Open
P=Posted
Q=Paused
R=Pending Scheduled Review
S=Pending Post Approval
T=Pending Award
U=Pending Award Approval
W=Post to Third Party Failed
X=Cancelled
Z=Inactive Version

Default Value: O

16 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
17 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
18 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish