ITEM_SS_VNDR_VW

(SQL View)
Index Back

Items by Supplier


SELECT A.VENDOR_SETID , A.VENDOR_ID , A.SETID , A.INV_ITEM_ID , B.DESCR , A.ITM_VNDR_PRIORITY , A.ITM_ID_VNDR , A.ITM_STATUS , A.PCT_ALLOC , A.VNDR_CATALOG_ID , B.STOCKLESS_FLG , A.COMMENTS_LONG FROM PS_ITM_VENDOR A , PS_PURCH_ITEM_ATTR B , PS_MASTER_ITEM_TBL C WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.ITM_STATUS = 'A' AND B.SETID = C.SETID AND B.INV_ITEM_ID = C.INV_ITEM_ID AND C.ITM_STATUS_CURRENT = '1' AND ((%CurrentDateIn >= B.PO_AVAIL_DT) AND (B.PO_UNAVAIL_DT > %CurrentDateIn))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_VNDSET_VW

3 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 ITM_VNDR_PRIORITY Number(3,0) SMALLINT NOT NULL Item Vendor Priority
7 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
8 ITM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
A=Active
D=Discntued
H=Hold
I=Inactive
X=To be Del

Default Value: A

9 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
10 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
11 STOCKLESS_FLG Character(1) VARCHAR2(1) NOT NULL Stockless Item
N=No
Y=Yes
12 COMMENTS_LONG Long Character CLOB Comment Text