DP_LOCS1_VW

(SQL View)
 Index Back

DP_LOCATIONS View #1

SELECT DISTINCT(DP_LOCATION) ,DP_LOCATION FROM PS_DP_FCITEMS WHERE DP_LOCATION <> ''

SELECT DISTINCT(DP_LOCATION) , DP_LOCATION FROM PS_DP_FCITEMS WHERE DP_LOCATION <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_LOCATION Character(5) VARCHAR2(5) NOT NULL DP_LOCATION
2 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION