PL_ITMREGVND_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT_IN , B.INV_ITEM_ID , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , B.ITM_VNDR_PRIORITY , B.LEAD_TIME , B.LEAD_TIME_OPT FROM PS_SHIPTO_TBL A , PS_ITM_REGION_VNDR B WHERE A.SETID = B.SETID AND A.SETID_REGION = B.SETID_REGION AND A.REGION_CD = B.REGION_CD AND B.INCL_IN_PLAN = 'Y' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SHIPTO_TBL C WHERE A.BUSINESS_UNIT_IN = C.BUSINESS_UNIT_IN AND A.SETID = C.SETID AND A.SHIPTO_ID = C.SHIPTO_ID AND C.EFFDT <= %CurrentDateIn AND C.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | ITM_VNDR_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Item Vendor Priority |
| 7 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 8 | LEAD_TIME_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Lead Time Option
0=Default 1=Use |