PROBINSTSETIDSHIP_TO_CUST_IDPL_PI_CUST_VW(SQL View) |
Index Back |
|---|---|
PL_PI_CUST_VWPL_PI_CUST_VW |
| SELECT DISTINCT A.PROBINST , B.SETID_CUSTOMER , A.SHIP_TO_CUST_ID , C.NAME1 FROM PS_PL_ORD_SCHEDULE A , PS_PL_ORD_HEADER B , PS_CUSTOMER C WHERE A.PROBINST = B.PROBINST AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ORDER_NO = B.ORDER_NO AND B.SETID_CUSTOMER = C.SETID AND A.SHIP_TO_CUST_ID = C.CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | SHIP_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |