BUSINESS_UNITREQ_IDDefault Value: NEXT
LINE_NBRDefault Value: 1
PV_REQ_SHPTO_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT L.BUSINESS_UNIT , L.REQ_ID , L.LINE_NBR , L.QTY_REQ , ' ' , CASE ( SELECT COUNT(DISTINCT X.SHIPTO_ID) FROM PS_REQ_LINE_SHIP X WHERE L.BUSINESS_UNIT = X.BUSINESS_UNIT AND L.REQ_ID = X.REQ_ID AND L.LINE_NBR = X.LINE_NBR) WHEN 1 THEN S.SHIPTO_ID ELSE 'MULT' END FROM PS_REQ_LINE L, PS_REQ_LINE_SHIP S WHERE L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.REQ_ID = S.REQ_ID AND L.LINE_NBR = S.LINE_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Default Value: NEXT |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
| 5 | PV_SHIPTO_STR | Character(30) | VARCHAR2(30) NOT NULL | Ship To |
| 6 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |