LINE_ROWPrompt Table: SPF_BID_ACTION
ENT=Enterprise
REQ=Requester
SUP=Supplier
SP_DB_SPSUB_VW(SQL View) |
Index Back |
|---|---|
SP Supplier SubmittalJoins the Requisition line and bid lines together. |
| SELECT L.BUSINESS_UNIT , L.SP_REQ_ID , L.LINE_NBR , V.VENDOR_ID , L.ROW_MODIFY_DATE , BH.BID_ID , BL.LINE_ROW , BL.BID_ACTION_TYPE , BL.CODE , BL.BID_TYP FROM PS_SPF_REQ_LINE L , PS_SPF_SOURCING S , PS_SPF_BID_HDR BH , PS_SPF_BID_LINE BL , PS_SPB_SERVICE_PRV V WHERE L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.SP_REQ_ID = S.SP_REQ_ID AND L.LINE_NBR = S.LINE_NBR AND S.SUBMITAL_NUMBER > 0 AND L.BUSINESS_UNIT = BH.BUSINESS_UNIT AND L.SP_REQ_ID = BH.SP_REQ_ID AND L.LINE_NBR = BH.LINE_NBR AND BH.BUSINESS_UNIT = BL.BUSINESS_UNIT AND BH.SP_REQ_ID = BL.SP_REQ_ID AND BH.LINE_NBR = BL.LINE_NBR AND BH.BID_ID = BL.BID_ID AND BH.SRVC_PROVIDER_ID = V.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SP_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Request ID |
| 3 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | ROW_MODIFY_DATE | DateTime(26) | TIMESTAMP | Modified Date Time |
| 6 | BID_ID | Number(10,0) | DECIMAL(10) NOT NULL | Bid Id |
| 7 | LINE_ROW |
Number(5,0) | INTEGER NOT NULL | Line Row |
| 8 | BID_ACTION_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Bid Action Type |
| 9 | CODE | Character(4) | VARCHAR2(4) NOT NULL |
CODE
Prompt Table: SPF_BID_ACTION |
| 10 | BID_TYP | Character(4) | VARCHAR2(4) NOT NULL |
Bid Type
ENT=Enterprise REQ=Requester SUP=Supplier |