EN_RTG_UITEM_VW

(SQL View)
 Index Back

Master Routing Item View

2/8/99 CN# EN800-12.0 lee - Created for master routing where-used inquiry.

SELECT DISTINCT (a.business_unit) , a.ref_routing_item , a.inv_item_id , b.descr60 , b.descr , b.unit_measure_std , b.lot_control , b.serial_control , a.source_code , a.revision_control , a.planner_cd FROM ps_bu_items_inv a , PS_MASTER_ITEM_TBL b , ps_set_cntrl_rec c WHERE c.recname='MASTER_ITEM_TBL' AND a.inv_item_id <> a.ref_routing_item AND a.inv_item_id=b.inv_item_id AND a.business_unit=c.setcntrlvalue AND b.setid=c.setid

  • Related Language Record: EN_RTG_UITM_LVW

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

    Prompt Table: BUS_UNIT_TBL_IN

    2 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    7 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y

    Y/N Table Edit

    8 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y

    Y/N Table Edit

    9 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
    1=Make
    2=Buy
    3=Expense
    4=Service
    5=Floor Stock
    6=Planning
    10 REVISION_CONTROL Character(1) VARCHAR2(1) NOT NULL Revision Control
    11 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code