RECV_L4_NOWN_VW

(SQL View)
 Index Back

Storage Lev 4 Prompting - View

for storage locations identified for Non Owned Items

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

# 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 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
7 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