EN_MMC_ERR3_VW

(SQL View)
Index Back

Mass Chg Exceptions View

11/14/97 WTK CN#EG750-3.0 : Created 08/13/98 CN#MG800-3.0 HK Added ps_en_bom_mmc_hdr to the view definition

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 = 'EN'

# 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