BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
MASS_MAINT_CODEEG_MMC_ERR3_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.mass_maint_code 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 | MASS_MAINT_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Mass Maintenance Code |