BUSINESS_UNITWC_GROUP_CODESPL_WC_GRPIC_VW(SQL View) |
Index Back |
|---|---|
Non-Critical Work Center GroupPlanning Non-Critical Work Center Groups |
| SELECT A.BUSINESS_UNIT , A.WC_GROUP_CODE , A.WORK_CENTER_CODE FROM PS_EN_WC_GRP_DTL A , PS_EN_WORK_CENTER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_CENTER_CODE = B.WORK_CENTER_CODE AND B.IGNORE_VIOLATIONS <> 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WC_GROUP_CODE |
Character(10) | VARCHAR2(10) NOT NULL | F-SMERENDA-87: Planning Work center groups |
| 3 | PL_RESOURCE_CODE | Character(10) | VARCHAR2(10) NOT NULL | 01/14/03 JC (CN#PL880-1): Added label SPL_WORK_CENTER |