EN_ICBOM_ITM_VW(SQL View) |
Index Back |
---|---|
Items accessible by a supplierCreated on 01/28/2000 RML View used as prompt table for BOM inquiry search page 8/23/00 lee - added related language view |
SELECT DISTINCT inv_item_id , descr FROM PS_EN_ICBOMVND_VW |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(18) | VARCHAR2(18) NOT NULL | Item ID | |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |