WM_CSINQT_VW

(SQL View)
 Index Back

SELECT H.BUSINESS_UNIT , H.SHOP_ID , H.WO_ID , T.WO_TASK_ID , H.WO_TYPE , H.PRIORITY_CD , %Substring(T.DESCR254 , 1 ,27) %Concat '...' , T.SUPERVISOR , T.ASSET_UP_FLG , T.LOCATION , T.ASSET_ID , T.BUSINESS_UNIT_AM , T.COMPLTED_DT , T.STATUS_CD , T.RES_LBR_EXIST , T.RES_MAT_EXIST , T.RES_PO_EXIST , T.RES_TLS_EXIST , T.SCHED_START_DT , T.SCHED_START_TIME , T.SCHED_END_DT , T.SCHED_END_TIME , T.WO_DURATION FROM PS_WM_WO_HDR H , PS_WM_WO_TSK T WHERE %Join(COMMON_KEYS, WM_WO_HDR H, WM_WO_TSK T)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_WM_NONVW

2 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Default Value: OPR_DEF_TBL_WM.SHOP_ID

Prompt Table: WM_SHOP_LOC_VW

3 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
4 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Default Value: 1

5 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE

6 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

Prompt Table: WM_PRIORITY

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor

Prompt Table: WM_SHOP_RES_VW

9 ASSET_UP_FLG Character(1) VARCHAR2(1) NOT NULL Asset in Production Flag
10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_VW

11 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VWA

12 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT_AM

Prompt Table: SP_BUS_AM_NONVW

13 COMPLTED_DT Date(10) DATE Completed Date
14 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_HDR

15 RES_LBR_EXIST Character(1) VARCHAR2(1) NOT NULL Labor exists flag - used on WO

Y/N Table Edit

Default Value: N

16 RES_MAT_EXIST Character(1) VARCHAR2(1) NOT NULL Inventory exists flag - indicates if inventory exists on WO

Y/N Table Edit

Default Value: N

17 RES_PO_EXIST Character(1) VARCHAR2(1) NOT NULL Procurement exists flag - indicates if Procurement exists in WO

Y/N Table Edit

Default Value: N

18 RES_TLS_EXIST Character(1) VARCHAR2(1) NOT NULL Tools exists flag - indicates if Tools exists on a WO

Y/N Table Edit

Default Value: N

19 SCHED_START_DT Date(10) DATE Scheduled Start Date
20 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
21 SCHED_END_DT Date(10) DATE Scheduled End Date
22 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time
23 WO_DURATION Number(8,2) DECIMAL(7,2) NOT NULL Estimated Work Order Duration

Default Value: WM_WO_HDR.WO_DURATION