BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
COMPONENT_IDSF_COMPWUSE3_VW(SQL View) |
Index Back |
|---|---|
Comp Where Used in Prdn-CompIDCN#SF800-20.0 MACN 02/23/99 - prompt table for component ID 06/14/00 lee - associated w/rlv sf_cmpwuse3_lvw. |
| select distinct a.business_unit, a.component_id, b.descr, b.inv_item_id, a.config_code from ps_sf_comp_list a, PS_MASTER_ITEM_TBL b, ps_sf_prdnid_headr c, ps_set_cntrl_rec d where a.business_unit = c.business_unit and a.business_unit = d.setcntrlvalue and d.recname = 'MASTER_ITEM_TBL' and b.setid = d.setid and a.component_id = b.inv_item_id and a.production_id = c.production_id and (c.prod_status between '15' and '40') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |