SP_DB_SPPLRS_VW(SQL View) |
Index Back |
|---|---|
SP Suppliers Per RequisitionDisplays supplier and requisition keys together. |
| SELECT L.BUSINESS_UNIT , L.SP_REQ_ID , L.LINE_NBR , S.VENDOR_ID , L.ROW_MODIFY_DATE , S.SUBMITAL_NUMBER , L.SP_REQ_STATUS , L.REQUESTOR_ID , L.RECRUITER , L.TE_APPROVER FROM PS_SPF_REQ_LINE L , PS_SPF_SOURCING S 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 |
| # | 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 | SUBMITAL_NUMBER | Number(4,0) | SMALLINT NOT NULL | Number of Times Submitted |
| 7 | SP_REQ_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Requisition Status for Service Procurement
A=Approved C=Complete D=Denied F=Filled O=Open P=Pending R=On Hold S=Sourced X=Canceled |
| 8 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 9 | RECRUITER | Character(15) | VARCHAR2(15) NOT NULL | Service Coordinator |
| 10 | TE_APPROVER | Character(30) | VARCHAR2(30) NOT NULL |
Time Approver
Prompt Table: SPF_APPROVER_VW |