PL_BU_GRP_BU_VW

(SQL View)
Index Back

PL_BU_GRP_BU_VW

PL_BU_GRP_BU_VW

SELECT A.PROBINST , B.BU_GROUP , B.BUSINESS_UNIT FROM PS_PL_PROBINST A , PS_PL_GROUP_IN B WHERE A.BU_GROUP = B.BU_GROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BU_GROUP Character(6) VARCHAR2(6) NOT NULL 08/16/01 EGS (CN#PL880-1.0): Added
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit