STOR_L4_ALL_VW

(SQL View)
 Index Back

Stor Lev 4 - Lot Alloc - Vw

Used for VMI

SELECT A.BUSINESS_UNIT , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.NON_OWN_FLAG , B.SHIP_TO_CUST_ID FROM PS_STOR_LOC_INV A , PS_IN_STOR_LOC_VMI B WHERE A.INSPECT_FLG = 'N' AND A.DELETE_STORLOC_FLG = 'N' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.STORAGE_AREA = B.STORAGE_AREA AND A.STOR_LEVEL_1 = B.STOR_LEVEL_1 AND A.STOR_LEVEL_2 = B.STOR_LEVEL_2 AND A.STOR_LEVEL_3 = B.STOR_LEVEL_3 AND A.STOR_LEVEL_4 = B.STOR_LEVEL_4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
3 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
4 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
5 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
6 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
7 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
8 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer