TML_L4_WIP_VW

(SQL View)
 Index Back

Wip Location Storage Area VW

Wip Location Storage Area VW for Item Template

SELECT DISTINCT sc.setid , c.storage_area , c.stor_level_1 , c.stor_level_2 , c.stor_level_3 , c.stor_level_4 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.wip_loc_flg = 'Y' AND c.delete_storloc_flg = 'N' AND a.business_unit = c.business_unit AND c.business_unit = sa.business_unit AND c.storage_area = sa.storage_area AND sa.st_level_display > '3'

# 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
4 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
5 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
6 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4