BUSINESS_UNITINV_ITEM_IDEN_ICBOMITEM_VW(SQL View) |
Index Back |
|---|---|
BOM Item View02/06/2000 RML Removed BOM Code as key field; prompt table does not allow Item ID to be enterable if code is made as key field. This view is used as prompt table by BOM Access by Supplier (under Maintain BOMs and REVs) 10/06/99 RML Created for EN800-2.0 - Used to get all items which have components |
| SELECT DISTINCT A.BUSINESS_UNIT , A.inv_item_id , B.DESCR 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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |