EN_BOM_MMCA_LVW

(SQL View)
 Index Back

BOM Mass Maint Assy RL View

01/16/98 LAJ CN#EG750-3.0 This view is used to join together assembly items and their descriptions. It will be used for the 'View Button' on the Component Search panel for BOM Mass Maintenance. 2/5/98 RS :Created as a Rel language View of EN_BOM_MMCA_LVW

select distinct %subrec(en_bom_sbr_lang,a), e.language_cd, e.descr from ps_en_bom_comps a, ps_set_cntrl_rec c, PS_INV_ITEMS d, ps_master_itm_lang e where a.business_unit = c.setcntrlvalue and c.recname = 'MASTER_ITEM_TBL' and e.setid = c.setid and e.setid = d.setid and a.inv_item_id = e.inv_item_id and a.inv_item_id = d.inv_item_id and d.effdt = (select MAX(effdt) from PS_INV_ITEMS where setid = d.setid and inv_item_id = e.inv_item_id and effdt <= %CurrentDateIn)

  • Related Language Record for EN_BOM_MMCA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: MG_ITEM_OWN_VW

    3 BOM_STATE Character(2) VARCHAR2(2) NOT NULL BOM State
    EN=Engineering
    PR=Manufacturing
    4 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
    PR=Production
    RW=Rework
    5 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
    6 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

    Prompt Table: %EDITTABLE

    7 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

    Prompt Table: %EDITTABLE2

    8 DATE_IN_EFFECT Date(10) DATE NOT NULL 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label

    Prompt Table: EN_REV_EDT_VW

    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description