RECV_AR_NOWN_VW

(SQL View)
 Index Back

Storage Area Prompting - View

for storage locations identified for Non Owned Items

SELECT DISTINCT business_unit , storage_area , 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 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