SCHED_GROUP_CDINV_ITEM_IDBUSINESS_UNITVENDOR_SETIDVENDOR_IDVNDR_LOCFROM_DTPL_SUP_CAP_VW(SQL View) |
Index Back |
|---|---|
PL_SUP_CAP_VWPL_SUP_CAP_VW |
| SELECT ICGR.SCHED_GROUP_CD , IVBA.INV_ITEM_ID , IVBA.BUSINESS_UNIT_IN , ICGR.VENDOR_SETID , ICGR.VENDOR_ID , ICGR.VNDR_LOC , ICGR.FROM_DT , ICGR.TO_DT , ICGR.QTY_MAX FROM PS_ITM_VND_BU_ATTR IVBA , PS_ITM_CAP_GRP_RNG ICGR WHERE ((IVBA.SCHED_GROUP_CD = ICGR.SCHED_GROUP_CD AND IVBA.SCHED_GROUP_CD <> ' ') OR (IVBA.BUSINESS_UNIT_IN = ICGR.BUSINESS_UNIT_IN AND IVBA.INV_ITEM_ID = ICGR.INV_ITEM_ID AND ICGR.INV_ITEM_ID <> ' ')) AND IVBA.VENDOR_SETID = ICGR.VENDOR_SETID AND IVBA.VENDOR_ID = ICGR.VENDOR_ID AND IVBA.VNDR_LOC = ICGR.VNDR_LOC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCHED_GROUP_CD |
Character(6) | VARCHAR2(6) NOT NULL | 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 7 | FROM_DT |
Date(10) | DATE | From Date |
| 8 | TO_DT | Date(10) | DATE | To Date |
| 9 | QTY_MAX | Number(16,4) | DECIMAL(15,4) NOT NULL | Maximum Quantity |