IN_PTWY_R3_VW

(SQL View)
 Index Back

Directed Ptwy Rule 3

This view is used to get the empty locations for directed putaway.

SELECT A.BUSINESS_UNIT , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.INV_ITEM_ID , A.CUBIC_CHK_FLG , A.CUR_LOC_VOLUME , %Round(%DecMult(A.LOC_HEIGHT, %DECMULT(A.LOC_LENGTH, A.LOC_WIDTH)),4) , A.WEIGHT_CHK_FLG , A.CUR_LOC_WEIGHT , A.WT_CAPACITY , A.NON_OWN_FLAG , A.INSPECT_FLG , A.INV_ITEM_ID , A.ITEM_SELECTION , A.NETTABLE_FLG , A.SUSPEND_FLG , A.AVAIL_STATUS , A.WIP_LOC_FLG , A.PHYS_CYC_INV_FLG FROM PS_STOR_LOC_INV A WHERE A.DELETE_STORLOC_FLG = 'N' AND (NOT EXISTS( SELECT 'Y' FROM PS_PHYSICAL_INV WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND STORAGE_AREA = A.STORAGE_AREA AND STOR_LEVEL_1 = A.STOR_LEVEL_1 AND STOR_LEVEL_2 = A.STOR_LEVEL_2 AND STOR_LEVEL_3 = A.STOR_LEVEL_3 AND STOR_LEVEL_4 = A.STOR_LEVEL_4 AND (QTY_RESERVED > 0 OR QTY <> 0))) AND NOT EXISTS( SELECT 'Y' FROM PS_STAGED_ITEM_INV WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND STORAGE_AREA = A.STORAGE_AREA AND STOR_LEVEL_1 = A.STOR_LEVEL_1 AND STOR_LEVEL_2 = A.STOR_LEVEL_2 AND STOR_LEVEL_3 = A.STOR_LEVEL_3 AND STOR_LEVEL_4 = A.STOR_LEVEL_4 AND PUTAWAY_STATUS = '1')

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 CUBIC_CHK_FLG Character(1) VARCHAR2(1) NOT NULL 11/10/1999 whs - added
9 CUR_LOC_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL 11/1/1999 whs - added
10 VOL_CAPACITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Volume Capacity
11 WEIGHT_CHK_FLG Character(1) VARCHAR2(1) NOT NULL 11/10/1999 whs - added
12 CUR_LOC_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL 11/10/1999 whs - added
13 WT_CAPACITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Weight Capacity
14 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
15 INSPECT_FLG Character(1) VARCHAR2(1) NOT NULL Inspection Location
16 INV_ITEM_ALIAS Character(18) VARCHAR2(18) NOT NULL Item Alias
17 ITEM_SELECTION Character(1) VARCHAR2(1) NOT NULL Item Selection
M=Multiple Items
S=Single Item
18 NETTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Nettable
19 SUSPEND_FLG Character(1) VARCHAR2(1) NOT NULL Location Suspend Flag
20 AVAIL_STATUS Character(1) VARCHAR2(1) NOT NULL Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected
21 WIP_LOC_FLG Character(1) VARCHAR2(1) NOT NULL WIP Location Flag
22 PHYS_CYC_INV_FLG Character(1) VARCHAR2(1) NOT NULL In Physical/Cyclic Inventory