RECV_L1_OWN_VW

(SQL View)
 Index Back

Storage Lev 1 Prompting - View

for storage locations identified for Owned Items

SELECT DISTINCT business_unit , storage_area , stor_level_1 , non_own_flag FROM PS_STOR_LOC_INV WHERE inspect_flg = 'N' AND delete_storloc_flg = 'N' AND non_own_flag = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
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 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes

Y/N Table Edit

Default Value: N