STOR_L4_NON_VW

(SQL View)
 Index Back

Stor Lvl4 nonowned - no insp


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 non_own_flag = 'Y' AND delete_storloc_flg = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: STOR_LOC_INV

2 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_LOC_INV

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