SPL_PI_WCG_VW

(SQL View)
Index Back

PI Work Center

01/14/03 JC (CN#PL880-1): Added

SELECT DISTINCT A.WC_GROUP_CODE , B.DESCR FROM PS_EN_WC_GRP_DTL A , PS_EN_WC_GRP B WHERE A.WC_GROUP_CODE = B.WC_GROUP_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WC_GROUP_CODE Character(10) VARCHAR2(10) NOT NULL F-SMERENDA-87: Planning Work center groups
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description