ORDER_SETIDORDER_VENDORORDER_LOCVNDR_LOC_ORD_VW(SQL View) |
Index Back |
|---|---|
Order From View |
| select DISTINCT A.SETID, A.VENDOR_ID, A.VNDR_LOC from PS_VENDOR_LOC A where EFFDT = (select max(EFFDT) from PS_VENDOR_LOC B where A.SETID = B.SETID and A.VENDOR_ID = B.VENDOR_ID and A.VNDR_LOC = B.VNDR_LOC and EFFDT <= %currentdatein) and EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ORDER_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Order Supplier SetID |
| 2 | ORDER_VENDOR |
Character(10) | VARCHAR2(10) NOT NULL | Order Supplier ID |
| 3 | ORDER_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Order Location |