WM_IN_UPNID_VW(SQL View) |
Index Back |
---|---|
WM Inventory UPN IDsNote: used in Sched PO Supplier Item Search |
SELECT DISTINCT A.SETID AS ITM_SETID , A.UPN_TYPE_CD , A.UPN_ID , B.DESCR60 FROM PS_ITEM_MFG_UPN_FS A , PS_MASTER_ITEM_TBL B WHERE A.UPN_ID <> ' ' AND B.SETID = A.SETID AND B.INV_ITEM_ID = A.INV_ITEM_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
2 | UPN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Universal Product Number Format Type |
3 | UPN_ID | Character(20) | VARCHAR2(20) NOT NULL | Universal Product Number |
4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |