IN_ENBOMHDR_VW(SQL View) |
Index Back |
|---|---|
BOM HeaderSCC 07/01/97 CN# PL700-DI-SCHEW-11: Use EN_BOM_HDR0_SBR which has no peoplecode instead of EN_BOM_HEAD_SBR. 11/22/99 TKI CN#SF800-14.0 Added related language record |
| SELECT a.business_unit , a.inv_item_id FROM ps_en_bom_header a , PS_IN_SETCNTRL_TMP b WHERE a.business_unit = b.setcntrlvalue |
| # | 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 |