EN_RTG_MST_LVW

(SQL View)
 Index Back

Master Routing Item View

8/1/99 CN# EN800-12.0 lee -related land vw for en_rtg_mst_vw

SELECT DISTINCT (a.business_unit) , a.ref_routing_item , d.rtg_type , d.rtg_state , e.language_cd , e.descr60 FROM ps_bu_items_inv a , PS_MASTER_ITEM_TBL b , ps_set_cntrl_rec c , ps_en_rtg_header d , ps_master_itm_lang e WHERE c.recname='MASTER_ITEM_TBL' AND a.inv_item_id <> a.ref_routing_item AND a.ref_routing_item=b.inv_item_id AND a.ref_routing_item=e.inv_item_id AND b.inv_item_id=e.inv_item_id AND a.business_unit=c.setcntrlvalue AND b.setid=c.setid AND e.setid=b.setid AND c.setid=e.setid AND d.business_unit = a.business_unit AND a.ref_routing_item = d.inv_item_id

  • Related Language Record for EN_RTG_MST_VW

    • # 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: BUS_UNIT_TBL_IN

    2 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item

    Prompt Table: %EDITTABLE

    3 RTG_TYPE Character(2) VARCHAR2(2) NOT NULL Routing Type
    PR=Production
    RW=Rework
    TD=Teardown
    4 RTG_STATE Character(2) VARCHAR2(2) NOT NULL Routing State
    EN=Engineering
    PR=Manufacturing
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description