STOR_AR_INSP_VW

(SQL View)
Index Back

Stor Area Exclude Insp Prompt


select distinct business_unit, storage_area from PS_STOR_LOC_INV where inspect_flg = 'N' 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