MG_NOWN3_ARE_VW

(SQL View)
Index Back

Storage Area Non-Owned View

02/01/1999 whs (CN#SF800-4.0) Do not allow viewing of storage area's marked for deletion.

SELECT DISTINCT a.business_unit , a.storage_area FROM PS_STOR_LOC_INV a WHERE a.non_own_flag = 'Y' AND (a.avail_status = '1' OR a.avail_status = '2' OR a.avail_status = '3') AND a.delete_storloc_flg = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_LOC_INV