WM_ADD_TE_VW

(SQL View)
 Index Back

MM Time Report Detail

MM Time Report Detail View

SELECT A.OPRID , A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , 0 , B.DESCR254 , '1' , B.STATUS_CD , B.INTERNAL_STATUS , B.BUSINESS_UNIT_PC , B.PROJECT_ID , B.ACTIVITY_ID FROM PS_WM_WOE_TW_VW A , PS_WM_WO_TSK B WHERE A.CHECKED = 'Y' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID AND B.WO_TASK_ID = A.WO_TASK_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: %EDIT_WO_ID

4 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Prompt Table: %EDIT_WO_TASK

5 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Prompt Table: %EDIT_RES_LINE

6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
7 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
8 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
9 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
10 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
11 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJID_BUGL_VW

12 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACT_FS