PUTAWAY_LOC_VW

(SQL View)
 Index Back

Putaway Location View


select distinct a.business_unit, a.inv_item_id, a.storage_area, a.stor_level_1, a.stor_level_2, a.stor_level_3, a.stor_level_4 from ps_physical_inv a, PS_STOR_LOC_INV b where b.business_unit = a.business_unit and b.storage_area = a.storage_area and b.stor_level_1 = a.stor_level_1 and b.stor_level_2 = a.stor_level_2 and b.stor_level_3 = a.stor_level_3 and b.stor_level_4 = a.stor_level_4 and b.suspend_flg = 'N' and b.phys_cyc_inv_flg = 'N' and (a.avail_status = '1' or a.avail_status = '2' or b.avail_status = '3')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
4 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
5 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
6 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
7 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4