AUC_AWSUM_PRBRK(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.BIDNUM , A.LINE_NBR , (CASE WHEN A.BID_QTY < %ROUND(E.MIN_QTY,4) AND F.AUC_FORMAT = 'R' THEN %DecMult (A.BID_QTY , E.MIN_PRICE) WHEN A.BID_QTY < %ROUND(E.MIN_QTY,4) AND F.AUC_FORMAT = 'F' THEN %DecMult (A.BID_QTY , E.MIN_PRICE) WHEN A.BID_QTY > %ROUND(E.MAX_QTY,4) AND F.AUC_FORMAT = 'R' THEN %DecMult (A.BID_QTY , E.BID_PBK_PRICE) WHEN A.BID_QTY > %ROUND(E.MAX_QTY,4) AND F.AUC_FORMAT = 'F' THEN %DecMult (A.BID_QTY , E.BID_PBK_PRICE) ELSE (CASE WHEN A.BID_QTY BETWEEN %ROUND(B.MIN_QTY,4) AND %ROUND(B.MAX_QTY,4) THEN %DecMult (A.BID_QTY , B.BID_PBK_PRICE) ELSE 0 END ) END ) AS BREAK_PRICE FROM PS_RESP_LN A , PS_AUC_AWD_RLPBRK B , PS_AUC_PRCVW C, PS_RESP_LN_FACTOR D , PS_AUC_AWD_RLBRK2 E, PS_AUC_HDR F WHERE 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 A.BIDDER_SETID = B.BIDDER_SETID AND A.BIDDER_ID = B.BIDDER_ID AND A.BIDDER_TYPE = B.BIDDER_TYPE AND A.BIDDER_LOC = B.BIDDER_LOC AND A.BIDNUM = B.BIDNUM AND A.LINE_NBR = B.LINE_NBR AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.AUC_ID = C.AUC_ID AND A.AUC_ROUND = C.AUC_ROUND AND A.AUC_VERSION = C.AUC_VERSION AND A.BIDDER_SETID = C.BIDDER_SETID AND A.BIDDER_ID = C.BIDDER_ID AND A.BIDDER_TYPE = C.BIDDER_TYPE AND A.BIDDER_LOC = C.BIDDER_LOC AND A.BIDNUM = C.BIDNUM AND A.LINE_NBR = C.LINE_NBR AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.AUC_ID = D.AUC_ID AND A.AUC_ROUND = D.AUC_ROUND AND A.AUC_VERSION = D.AUC_VERSION AND A.BIDDER_SETID = D.BIDDER_SETID AND A.BIDDER_ID = D.BIDDER_ID AND A.BIDDER_TYPE = D.BIDDER_TYPE AND A.BIDDER_LOC = D.BIDDER_LOC AND A.BIDNUM = D.BIDNUM AND A.LINE_NBR = D.LINE_NBR AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.AUC_ID = E.AUC_ID AND A.AUC_ROUND = E.AUC_ROUND AND A.AUC_VERSION = E.AUC_VERSION AND A.BIDDER_SETID = E.BIDDER_SETID AND A.BIDDER_ID = E.BIDDER_ID AND A.BIDDER_TYPE = E.BIDDER_TYPE AND A.BIDDER_LOC = E.BIDDER_LOC AND A.BIDNUM = E.BIDNUM AND A.LINE_NBR = E.LINE_NBR AND A.BUSINESS_UNIT = F.BUSINESS_UNIT AND A.AUC_ID = F.AUC_ID AND A.AUC_ROUND = F.AUC_ROUND AND A.AUC_VERSION = F.AUC_VERSION AND(CASE WHEN A.BID_QTY < %ROUND(E.MIN_QTY,4) AND F.AUC_FORMAT = 'R' THEN %DecMult (A.BID_QTY , E.MIN_PRICE) WHEN A.BID_QTY < %ROUND(E.MIN_QTY,4) AND F.AUC_FORMAT = 'F' THEN %DecMult (A.BID_QTY , E.MIN_PRICE) WHEN A.BID_QTY > %ROUND(E.MAX_QTY,4) AND F.AUC_FORMAT = 'R' THEN %DecMult (A.BID_QTY , E.BID_PBK_PRICE) WHEN A.BID_QTY > %ROUND(E.MAX_QTY,4) AND F.AUC_FORMAT = 'F' THEN %DecMult (A.BID_QTY , E.BID_PBK_PRICE) ELSE (CASE WHEN A.BID_QTY BETWEEN %ROUND(B.MIN_QTY,4) AND %ROUND(B.MAX_QTY,4) THEN %DecMult (A.BID_QTY , B.BID_PBK_PRICE) ELSE 0 END ) END ) > 0 |
| # | 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 | BIDDER_SETID | Character(5) | VARCHAR2(5) NOT NULL | Bidder Setid |
| 6 | BIDDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 7 | BIDDER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Bidder C=Customer P=Public U=Uploaded V=Supplier |
| 8 | BIDDER_LOC | Character(10) | VARCHAR2(10) NOT NULL | Bidder Location |
| 9 | BIDNUM | Signed Number(6,0) | DECIMAL(5) NOT NULL | Bid ID |
| 10 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 11 | AUC_HDR_PRICE | Number(19,6) | DECIMAL(18,6) NOT NULL | Event Price |