STOR_AREA_SR_VW

(SQL View)
Index Back

Storage Area Prompting - View


select distinct business_unit , storage_area from PS_STOR_LOC_INV WHERE 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