TML_L4_RPL_VW

(SQL View)
 Index Back

Rpl Location Storage Area VW

Rpl 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.inspect_flg = 'N' 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 SF_RPL_STOR_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
3 SF_RPL_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL Level 1
4 SF_RPL_STOR_LEV2 Character(4) VARCHAR2(4) NOT NULL Level 2
5 SF_RPL_STOR_LEV3 Character(4) VARCHAR2(4) NOT NULL Level 3
6 SF_RPL_STOR_LEV4 Character(4) VARCHAR2(4) NOT NULL Level 4