WM_INV_ITM_VW (SQL View)	Index Back
BU items Inventory for WM Inventory Items view for Work Management

WM_INV_ITM_VW

(SQL View)

BU items Inventory for WM

Inventory Items view for Work Management

SELECT A.BUSINESS_UNIT , B.INV_ITEM_ID , A.BUSINESS_UNIT_IN , C.DESCR , C.UNIT_MEASURE_STD , B.SOURCE_CODE , B.INVENTORY_ITEM , C.SERIAL_CONTROL , C.LOT_CONTROL , C.INV_ITEM_GROUP , C.INV_PROD_FAM_CD , CASE WHEN B.DT_TIMESTAMP > C.LAST_DTTM_UPDATE THEN B.DT_TIMESTAMP ELSE C.LAST_DTTM_UPDATE END FROM PS_BUS_UNIT_TBL_WM A , PS_BU_ITEMS_INV B , PS_MASTER_ITEM_TBL C , PS_SET_CNTRL_REC D WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT_IN AND B.INVENTORY_ITEM = 'Y' AND B.ITM_STATUS_CURRENT IN ('1','2','3') AND A.BUSINESS_UNIT_IN = D.SETCNTRLVALUE AND D.RECNAME = 'MASTER_ITEM_TBL' AND C.CFG_CODE_OPT = 'N' AND B.STAGED_DATE_FLAG = 'N' AND C.SETID = D.SETID AND C.INV_ITEM_ID = B.INV_ITEM_ID

Related Language Record: WM_INV_ITM_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

6 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning

7 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
N=No
Y=Yes

8 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y

9 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y

10 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
Prompt Table: INV_ITEM_GROUP

11 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
Prompt Table: INV_ITEM_FAM

12 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
6	SOURCE_CODE	Character(2)	VARCHAR2(2) NOT NULL	8/5/97 lee - inactivated source code 4 - service 1=Make 2=Buy 3=Expense 4=Service 5=Floor Stock 6=Planning
7	INVENTORY_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Inventory Item N=No Y=Yes
8	SERIAL_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Serial Control N=N Y=Y
9	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y
10	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group Prompt Table: INV_ITEM_GROUP
11	INV_PROD_FAM_CD	Character(10)	VARCHAR2(10) NOT NULL	Family Prompt Table: INV_ITEM_FAM
12	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.