MG_OWN3_AREA_VW

(SQL View)
 Index Back

Storage Area Owned View

07/07/99 mmt CN#CM800-4.0 Created view for proper prompting on kit issues/returns when a consigned component is being returned.

SELECT DISTINCT a.business_unit , a.storage_area FROM PS_STOR_LOC_INV a WHERE a.non_own_flag = 'N' 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