PV_ITM_VNDPR_VW (SQL View)	Index Back
Item Supplier Priority Selects the smallest supplier priority that is active.

PV_ITM_VNDPR_VW

(SQL View)

Item Supplier Priority

Selects the smallest supplier priority that is active.

SELECT C.SETID , C.INV_ITEM_ID , MIN(C.ITM_VNDR_PRIORITY) FROM PS_ITM_VENDOR C WHERE C.ITM_STATUS = 'A' GROUP BY C.SETID, C.INV_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

3 ITM_VNDR_PREFPRIOR Number(3,0) SMALLINT NOT NULL Item Vendor Priority

#	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
3	ITM_VNDR_PREFPRIOR	Number(3,0)	SMALLINT NOT NULL	Item Vendor Priority