VNDR_LOCVENDOR_LOC_VW1(SQL View) |
Index Back |
|---|---|
Supplier SETID Loc View |
| select distinct A.VNDR_LOC from PS_VENDOR_LOC A where A.EFFDT = (select max(B.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 B.EFFDT <= %currentdatein) and A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |