BUSINESS_UNIT_AMPrompt Table: SP_BU_AM_NONVW
ASSET_IDWM_WR_ASSET_VW(SQL View) |
Index Back |
|---|---|
WR Asset Info View |
| SELECT A.BUSINESS_UNIT AS BUSINESS_UNIT_AM , A.ASSET_ID , A.DESCR AS ASSET_DESCR30 , A.DESCR_LONG AS ASSET_DESCR , A.TAG_NUMBER , A.SERIAL_ID , ( SELECT COUNT(*) FROM PS_WM_WR_OPNWO2_VW I WHERE I.BUSINESS_UNIT_AM = A.BUSINESS_UNIT AND I.ASSET_ID = A.ASSET_ID) AS ASSET_OPEN_WO_CNT FROM PS_ASSET A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_AM |
Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | ASSET_DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Asset Description |
| 4 | ASSET_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Asset Description |
| 5 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 6 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 7 | ASSET_OPEN_WO_CNT | Number(5,0) | INTEGER NOT NULL | Asset Open WO Count |