WM_WOPO_HASH_VW (SQL View)	Index Back
Non-Inventory Work Order Hash 10/14/04 EGS: Created by inventory, owned by Work Management

WM_WOPO_HASH_VW

(SQL View)

Non-Inventory Work Order Hash

10/14/04 EGS: Created by inventory, owned by Work Management

SELECT A.HASH_KEY ,A.BUSINESS_UNIT ,A.WO_ID ,A.WO_TASK_ID ,A.RES_LN_NBR ,A.RSRC_TYPE ,B.INV_ITEM_ID FROM PS_WM_WO_PO_HASH A , PS_WM_WO_SCHED_PO B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID AND A.WO_TASK_ID = B.WO_TASK_ID AND A.RES_LN_NBR = B.RES_LN_NBR AND A.RSRC_TYPE = B.RSRC_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HASH_KEY Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

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

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

6 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
Default Value: 3

7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HASH_KEY	Character(28)	VARCHAR2(28) NOT NULL	08/11/04 EGS: Created
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
4	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
5	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No.
6	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material Default Value: 3
7	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID