TML_AREA_VW

(SQL View)
 Index Back

Storage Area Prompting - View2


SELECT DISTINCT sc.setid , c.storage_area FROM ps_set_cntrl_rec sc , PS_BUS_UNIT_TBL_IN a , ps_bus_unit_tbl_fs b , ps_stor_loc_inv c WHERE sc.recname = 'MASTER_ITEM_TBL' AND a.business_unit = sc.setcntrlvalue AND a.business_unit = b.business_unit AND a.bu_status = '1' AND a.business_unit = c.business_unit AND c.delete_storloc_flg = 'N'

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

Prompt Table: STOR_LOC_INV