WM_WO_INSRAM_VW(SQL View) |
Index Back |
---|---|
WO Inspect Revw Alert Msg View |
SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.INSPECTION_ID , A.INSP_ACTIVITY_NBR , A.INSP_STEP_NBR , A.EVAL_ALRTMSG_OPRID , A.EVAL_ALRTMSG_DTTM , B.LANGUAGE_CD , B.WL_SUBJECT , B.EMAIL_TEXTLONG FROM PS_WM_WO_INSPC_EVL A , PS_PT_WF_NOTFY_TBL B WHERE A.EVAL_ALRTMSG_DTTM IS NOT NULL AND B.CREATEOPRID = A.EVAL_ALRTMSG_OPRID AND B.CREATEDTTM = A.EVAL_ALRTMSG_DTTM |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: WM_WO_INSPC_EVL.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW |
|
2 | Character(10) | VARCHAR2(10) NOT NULL |
Work Order Identification
Default Value: WM_WO_INSPC_EVL.WO_ID Prompt Table: WM_FTRK_WOI_PVW |
|
3 | Number(5,0) | INTEGER NOT NULL |
Task Number
Default Value: WM_WO_INSPC_EVL.WO_TASK_ID Prompt Table: WM_FTRK_TSK_PVW |
|
4 | Character(10) | VARCHAR2(10) NOT NULL |
Inspection ID
Default Value: WM_WO_INSPC_EVL.INSPECTION_ID |
|
5 | Number(5,0) | INTEGER NOT NULL |
Activity Number
Default Value: WM_WO_INSPC_EVL.INSP_ACTIVITY_NBR |
|
6 | Number(5,0) | INTEGER NOT NULL |
Step Number
Default Value: WM_WO_INSPC_EVL.INSP_STEP_NBR |
|
7 | Character(30) | VARCHAR2(30) NOT NULL |
Created By
Default Value: WM_WO_INSPC_EVL.EVAL_ALRTMSG_OPRID |
|
8 | DateTime(26) | TIMESTAMP |
Created On
Default Value: WM_WO_INSPC_EVL.EVAL_ALRTMSG_DTTM |
|
9 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
Default Value: ENG |
10 | WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
11 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |