EN_BOM_MMCA_VW

(SQL View)
 Index Back

BOM Mass Maint Assy by Comp

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/16/98 RS : Created a Rel language view EN_BOM_MMCA_LVW RL View Type MFG C2 10/09/02 PWF PL880-1.0 Removal of EP_OP_SEQ from subrecord

SELECT DISTINCT %subrec(en_bom_cmp0_sbr,a) , b.descr FROM ps_en_bom_comps a , PS_MASTER_ITEM_TBL b , ps_set_cntrl_rec c , ps_inv_items d WHERE a.business_unit = c.setcntrlvalue AND c.recname = 'MASTER_ITEM_TBL' AND b.setid = c.setid AND b.setid = d.setid AND a.inv_item_id = b.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 = b.inv_item_id AND effdt <= %CurrentDateIn)

  • Related Language Record: EN_BOM_MMCA_LVW

    • # 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 DATE_OBSOLETE Date(10) DATE NOT NULL Obsolete Date

    Prompt Table: EN_REV_ODT_VW

    10 POS_NBR Number(4,0) SMALLINT NOT NULL Position Number
    11 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
    12 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
    ASY=Assembly
    ORD=Order

    Default Value: ASY

    13 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield

    Default Value: 100

    14 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number
    15 PENDING_STATUS Character(3) VARCHAR2(3) NOT NULL Status
    ACT=Active
    PEN=Pending

    Default Value: ACT

    16 SUB_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL Subcontract Supply

    Y/N Table Edit

    Default Value: N

    17 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    18 TEARDOWN_FLAG Character(1) VARCHAR2(1) NOT NULL 01/28/99 jnw (CN#SF800-13) added field

    Y/N Table Edit

    19 ROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

    Y/N Table Edit

    Default Value: N

    20 EN_SUBS_EXIST Character(1) VARCHAR2(1) NOT NULL KPN 08/23/02: Added label PL_SUBS_EXIST
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    21 INV_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size
    22 INV_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height
    23 INV_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length
    24 INV_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width
    25 INV_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
    26 INV_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Volume
    27 UNIT_MEASURE_DIM Character(3) VARCHAR2(3) NOT NULL Dimension UOM

    Prompt Table: UNITS_TBL

    28 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

    Prompt Table: UNITS_TBL

    29 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

    Prompt Table: UNITS_TBL

    30 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    31 INCR_CONS_TYPE Character(1) VARCHAR2(1) NOT NULL 07/22/02 EGS (CN#PL880-1): Added
    1=None
    2=Over Time

    Default Value: 1

    32 INCR_CONS_OFFSET Number(16,4) DECIMAL(15,4) NOT NULL 07/22/02 EGS (CN#PL880-1): Added
    33 COMP_REV Character(4) VARCHAR2(4) NOT NULL 03/29/00 ST Created new field Component Revision.
    34 DESCR Character(30) VARCHAR2(30) NOT NULL Description