SP_BUINWO_OPRVW

(SQL View)
 Index Back

IN/Work Order BU - Opr Vw


SELECT DISTINCT s.oprid , b.business_unit_in , a.business_unit , f.descr FROM PS_WM_WO_TSK a , ps_bus_unit_tbl_wm b , ps_bus_unit_tbl_fs f , ps_sec_bu_opr s WHERE a.internal_status NOT IN ('05','06','07') AND b.business_unit = a.business_unit AND f.business_unit = a.business_unit AND s.business_unit = a.business_unit

  • Related Language Record: SP_BUINWO_OPLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    3 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description