WM_INSP_WOI_PVW

(SQL View)
 Index Back

WO Inspection - WO ID Prmpt Vw


SELECT A.BUSINESS_UNIT , A.WO_ID , A.DESCR254 , A.SHOP_ID , A.PRIORITY_CD , A.SRVC_GRP_ID , A.WO_TYPE , A.STATUS_CD , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.WO_SOURCE_CD FROM PS_WM_WO_HDR A WHERE A.INTERNAL_STATUS NOT IN ('06','07') AND EXISTS ( SELECT 'X' FROM PS_WM_WO_TSK I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.WO_ID = A.WO_ID AND I.INTERNAL_STATUS NOT IN ('06','07') AND I.ASSET_ID <> ' ' AND EXISTS ( SELECT 'X' FROM PS_WM_TSK_INSPECT J WHERE J.BUSINESS_UNIT = I.BUSINESS_UNIT AND J.WO_ID = I.WO_ID AND J.WO_TASK_ID = I.WO_TASK_ID AND J.WO_INSPL_TMPLT_ID <> ' ' AND J.INSPECTION_ID IN ('NEXT',' ')))

# 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_WM.BUSINESS_UNIT

Prompt Table: SP_BU_WM_NONVW

2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
4 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Default Value: OPR_DEF_TBL_WM.SHOP_ID

Prompt Table: WM_SHOP_LOC_VW

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

Prompt Table: WM_PRIORITY

6 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

Default Value: OPR_DEF_TBL_WM.SRVC_GRP_ID

Prompt Table: WM_SRVC_GRP_BU

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

Prompt Table: WM_WO_TYPE

8 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_HDR

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

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT_AM

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: WM_ASSET_VWA

11 WO_SOURCE_CD Character(4) VARCHAR2(4) NOT NULL Work order source code
1=Third Party
2=CRM Help Desk
3=Work Order
4=Service Request
5=Preventive Maintenance
6=Project Costing
7=Express Work Order
8=Condition-based Maintenance
9=WO Inspection