IN_PTWY_R4_VW

(SQL View)
 Index Back

Directed Ptwy Rule 4

This view is used to get the locations that already contain the item being putaway for directed putaway.

SELECT DISTINCT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , B.CUBIC_CHK_FLG , B.CUR_LOC_VOLUME , %Round(%DecMult(B.LOC_HEIGHT, %DECMULT(B.LOC_LENGTH, B.LOC_WIDTH)),4) , B.WEIGHT_CHK_FLG , B.CUR_LOC_WEIGHT , B.WT_CAPACITY , B.NON_OWN_FLAG , B.INSPECT_FLG , B.INV_ITEM_ID , B.ITEM_SELECTION , B.NETTABLE_FLG , B.SUSPEND_FLG , B.AVAIL_STATUS , B.WIP_LOC_FLG , B.PHYS_CYC_INV_FLG FROM PS_PHYSICAL_INV A , PS_STOR_LOC_INV B WHERE (A.QTY_RESERVED <> 0 OR A.QTY <> 0) 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 AND B.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
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
4 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
5 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
6 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
7 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
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