Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
RUN_CNTL_IDEG_MMC_ERR5_VW(SQL View) |
Index Back |
|---|---|
Mass Chg Exceptions View08/13/98 CN#MG800-3.0 HK : Mass change exceptions view for engineering;created. |
| SELECT DISTINCT a.business_unit ,a.run_cntl_id FROM ps_en_bom_err_tmp a , PS_EN_BOM_MMC_HDR b WHERE a.en_transfer_source = 'M' AND a.business_unit = b.business_unit AND a.mass_maint_code = b.mass_maint_code AND b.origin = 'EG' |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |