FROM_LV4_INV_VW

(SQL View)
Index Back

Storage Lev 4 Prompting - View


select distinct business_unit, storage_area, stor_level_1, stor_level_2, stor_level_3, stor_level_4 from PS_STOR_LOC_INV

# 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 FROM_STOR_AREA Character(5) VARCHAR2(5) NOT NULL From storage area
3 FROM_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL From Storage Level 1
4 FROM_STOR_LEV2 Character(4) VARCHAR2(4) NOT NULL From Storage Level 2
5 FROM_STOR_LEV3 Character(4) VARCHAR2(4) NOT NULL From Storage Level 3
6 FROM_STOR_LEV4 Character(4) VARCHAR2(4) NOT NULL From Storage Level 4