EN_BOM_MMCE_VW

(SQL View)
 Index Back

BOM Mass Maint Components

11/97 LAJ CN#EG750-3.0 This view is used in BOM Mass Maintenance to allow the user to only select components that exist on Engineering BOMs. 01/15/98 LAJ Updated view to include components on Manufacturing BOMs as well. 04/20/99 LAJ CN#EN800-3.0 Mass Maintenance can now be executed on other BOM types, so changed 'WHERE BOM_TYPE = 'PR'" to 'WHERE BOM_TYPE <> 'PL'". Added description. Created related language view EN_BOMCE_LVW. 08/25/2003 Incident 602355001 Bundle resolution 133260. Set component_id to a search field so that list of displayed components is filtered properly when user enters partial component and hits search button

SELECT DISTINCT a.business_unit , a.component_id , b.descr FROM ps_en_bom_comps a , PS_MASTER_ITEM_TBL b , ps_set_cntrl_rec c WHERE a.business_unit = c.setcntrlvalue AND c.recname = 'MASTER_ITEM_TBL' AND b.setid = c.setid AND a.component_id = b.inv_item_id AND (a.bom_state='EN' OR a.bom_state='PR')

  • Related Language Record: EN_BOM_MMCE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    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