SPF_GET_BINFWOS

(SQL View)
 Index Back

get bid info

Gets the Bid information

SELECT A.BUSINESS_UNIT , A.BIDNUM , A.BIDDER_SETID , A.BIDDER_ID , A.AUC_ID , D.BUSINESS_UNIT , D.SP_REQ_ID , D.LINE_NBR , D.BID_ID ,D.WORK_ORDER_ID ,D.SEQNBR , D.SRVC_PROVIDER_ID , D.BIDNUM , E.SPF_RATE , E.BID_ACTION_TYPE , E.CODE , D.PROVIDER_CONTACT , D.REQUESTOR_ID , E.LINE_ROW , E.SPF_RATE_VNDR , E.SPF_RATE_BSE , E.CURRENCY_CD_VNDR , E.SPF_BID_LINE_TOTAL , E.SPF_BIDLN_TTL_BSE , E.SP_MSP_PERCENT ,%Round (%DecMult((1 + %DecDiv(E.SP_MSP_PERCENT,100)) , E.SPF_RATE_VNDR ) ,4) , E.RATE_MULT , E.RATE_DIV , E.RATE_EFFDT , E.CURRENCY_CD_BASE , D.VENDOR_ID , B.AUC_SOURCE , D.LINKEDWORDER ,'M' FROM PS_RESP_HDR A , PS_AUC_COPY_XREF B , PS_SPF_BID_HDR D , PS_SPF_BID_LINE E WHERE A.AUC_ID = B.AUC_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.BUSINESS_UNIT = B.AUC_SOURCE_BUSETID AND D.WORK_ORDER_ID = B.AUC_SOURCE_ID AND D.SEQNBR = B.AUC_SOURCE_LINE AND B.AUC_SOURCE = 'W' AND D.BIDNUM = A.BIDNUM AND D.VENDOR_SETID = A.BIDDER_SETID AND D.VENDOR_ID = A.BIDDER_ID AND E.BUSINESS_UNIT = D.BUSINESS_UNIT AND E.BID_ID = D.BID_ID AND E.LINE_ROW = ( SELECT MAX(LINE_ROW) FROM PS_SPF_BID_LINE F WHERE F.BUSINESS_UNIT = D.BUSINESS_UNIT AND F.BID_ID = D.BID_ID AND F.BID_TYP = 'SUP')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU
2 BIDNUM_POSTED Signed Number(6,0) DECIMAL(5) NOT NULL Last Posted Bid Number
3 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
4 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
5 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
9 BID_ID Number(10,0) DECIMAL(10) NOT NULL Bid Id
10 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
11 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
12 SRVC_PROVIDER_ID Character(15) VARCHAR2(15) NOT NULL Service Provider
13 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
14 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
15 BID_ACTION_TYPE Character(5) VARCHAR2(5) NOT NULL Bid Action Type
16 CODE Character(4) VARCHAR2(4) NOT NULL CODE
17 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
18 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
19 LINE_ROW Number(5,0) INTEGER NOT NULL Line Row
20 SPF_RATE_FILL Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate
21 SPF_RATE_FILL_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate in Base currency
22 CURRENCY_CD_VNDR Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
23 SPF_BID_LINE_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL field used to store the total bid amount for deliverable based spro reqs
24 SPF_BIDLN_TTL_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL bid line total in the base currency
25 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
26 FULLY_LOADED_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL FULLY LOADED RATE
27 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
28 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
29 RATE_EFFDT Date(10) DATE Rate Effective Date
30 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
31 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
32 AUC_SOURCE Character(1) VARCHAR2(1) NOT NULL Source Type
A=Event
B=MBOM
C=Contract
E=EBOM
I=RFI
L=Planning
P=PO
R=Req
T=Template
W=WO Replace
33 LINKEDWORDER Character(15) VARCHAR2(15) NOT NULL Linked Work Order
34 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource