BUSINESS_UNITPrompt Table: SP_BU_WM_NONVW
WO_IDWM_WO_WRCNTS_VW(SQL View) |
Index Back |
|---|---|
WO Assoc SR Counts View |
| SELECT A.BUSINESS_UNIT , A.WO_ID , ( SELECT COUNT(DISTINCT I.BUSINESS_UNIT_WR) FROM PS_WM_WO_ASSCSR_VW I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.WO_ID = A.WO_ID) AS WO_ASSOC_WRBU_CNT , ( SELECT COUNT(J.WR_ID) FROM PS_WM_WO_ASSCSR_VW J WHERE J.BUSINESS_UNIT = A.BUSINESS_UNIT AND J.WO_ID = A.WO_ID) AS WO_ASSOC_WRID_CNT FROM PS_WM_WO_ASSCSR_VW A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_WM_NONVW |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | WO_ASSOC_WRBU_CNT | Number(3,0) | SMALLINT NOT NULL | WO Service Unit Count |
| 4 | WO_ASSOC_WRID_CNT | Number(3,0) | SMALLINT NOT NULL | WO Service Request Count |