EG_NOTINVITM_VW (SQL View)	Index Back
Items that aren't inv items Items that are not inventory items 02/23/98 wtk : Deleted DESCR and added keys 05/25/99 Lee CN# MG800-4.0 Changed to select non-inventory, non-expensed items. Used values based on the business unit (bu_items_inv).

EG_NOTINVITM_VW

(SQL View)

Items that aren't inv items

Items that are not inventory items 02/23/98 wtk : Deleted DESCR and added keys 05/25/99 Lee CN# MG800-4.0 Changed to select non-inventory, non-expensed items. Used values based on the business unit (bu_items_inv).

SELECT B.SETID, B.INV_ITEM_ID FROM PS_BU_ITEMS_INV A, PS_MASTER_ITEM_TBL B, PS_SET_CNTRL_REC C WHERE A.BUSINESS_UNIT=C.SETCNTRLVALUE AND C.RECNAME='MASTER_ITEM_TBL' AND B.SETID=C.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND (A.INVENTORY_ITEM='N' AND A.SOURCE_CODE <>'3')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID