BUSINESS_UNIT_AMRE_LS_PPTY_CNT(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT_AM , COUNT(A.BUSINESS_UNIT_AM) FROM PS_RE_LS_PPTY A , PS_RE_LS B WHERE A.LS_KEY = B.LS_KEY AND A.ASSET_SEQ_NBR = 1 AND B.SYSTEM_SOURCE = 'BAM' GROUP BY A.BUSINESS_UNIT_AM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_AM |
Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 2 | ROWCOUNT1 | Number(12,0) | DECIMAL(12) NOT NULL | Row Count |