BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
INV_ITEM_IDEN_MMC_ERR2_VW(SQL View) |
Index Back |
|---|---|
Mass Maint Exceptions View11/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 11/99 LAJ...Removed process_instance so that all items for the BU can be displayed w/o knowing the process_instance. |
| SELECT DISTINCT a.business_unit , a.inv_item_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 = '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 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |