TML_L1_NON_VW

(SQL View)
Index Back

Stor Area Exclude Insp Prompt


SELECT DISTINCT sc.setid , c.storage_area , c.stor_level_1 FROM ps_set_cntrl_rec sc , PS_BUS_UNIT_TBL_IN a , ps_bus_unit_tbl_fs b , ps_stor_loc_inv c , ps_stor_area_inv sa 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.inspect_flg = 'N' AND c.delete_storloc_flg = 'N' AND c.non_own_flag = 'Y' AND c.business_unit = sa.business_unit AND c.storage_area = sa.storage_area AND sa.st_level_display > '0'

# 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
3 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1