SETIDSF_RPL_VENDOR_IDVNDR_LOCEFFDTVNDR_LOC_VW3(SQL View) |
Index Back |
|---|---|
Supplier Locations (Flw)03/23/2000 MDS SF800-30.0: Copied this view from supp_loc_vw and replaced supplier_id with sf_rpl_supplier_id so that it can be used for Flow processing. 8/23/00 lee - added related lang view |
| select A.SETID, A.VENDOR_ID, A.VNDR_LOC, A.EFFDT, B.DESCR from PS_VENDOR_LOC A, PS_VNDR_LOC_SCROL B where A.SETID = B.SETID and A.VENDOR_ID = B.VENDOR_ID and A.VNDR_LOC = B.VNDR_LOC and A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SF_RPL_VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Replenishment Vendor ID |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |