RE_LS_TRM_CNT

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , COUNT(A.BUSINESS_UNIT) FROM PS_RE_LS A , PS_RE_LS_TRM B WHERE A.LS_KEY = B.LS_KEY AND A.SYSTEM_SOURCE = 'BAM' GROUP BY A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ROWCOUNT1 Number(12,0) DECIMAL(12) NOT NULL Row Count