MG_NOWIPTO_A_VW (SQL View)	Index Back
StorArea NonOwn WIP PrompView 02/01/1999 whs (CN#SF800-4.0) Do not allow viewing of storage area's marked for deletion.

MG_NOWIPTO_A_VW

(SQL View)

StorArea NonOwn WIP PrompView

02/01/1999 whs (CN#SF800-4.0) Do not allow viewing of storage area's marked for deletion.

SELECT DISTINCT business_unit , storage_area FROM PS_STOR_LOC_INV WHERE non_own_flag = 'Y' AND wip_loc_flg = 'Y' AND delete_storloc_flg = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT

2 NON_OWN_STOR_AREA Character(5) VARCHAR2(5) NOT NULL Non Own Storage Area
Prompt Table: STOR_LOC_INV

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_TO	Character(5)	VARCHAR2(5) NOT NULL	04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
2	NON_OWN_STOR_AREA	Character(5)	VARCHAR2(5) NOT NULL	Non Own Storage Area Prompt Table: STOR_LOC_INV