AUC_AWD_POBU_VW

(SQL View)
Index Back

SELECT a.business_unit_ss AS business_unit , a.business_unit AS business_unit_po , b.descr FROM PS_BUS_UNIT_TBL_PM a , ps_bus_unit_tbl_fs b WHERE a.business_unit = b.business_unit AND business_unit_ss <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description