STOR_L4_PHY_VW4

(SQL View)
 Index Back

Storage Lev 4 Phys Prompt - Vw

View of PHYSICAL_INV used in Feedback with no QTY check for when negatives are allowed.

SELECT DISTINCT business_unit , inv_item_id , storage_area , stor_level_1 , stor_level_2 , stor_level_3 , stor_level_4 FROM ps_physical_inv WHERE (AVAIL_STATUS = '1' OR AVAIL_STATUS = '2') AND EXISTS ( SELECT 'x' FROM PS_STOR_LOC_INV WHERE ps_physical_inv.business_unit = PS_STOR_LOC_INV.business_unit AND ps_physical_inv.storage_area = PS_STOR_LOC_INV.storage_area AND ps_physical_inv.stor_level_1 = PS_STOR_LOC_INV.stor_level_1 AND ps_physical_inv.stor_level_2 = PS_STOR_LOC_INV.stor_level_2 AND ps_physical_inv.stor_level_3 = PS_STOR_LOC_INV.stor_level_3 AND ps_physical_inv.stor_level_4 = PS_STOR_LOC_INV.stor_level_4 AND PS_STOR_LOC_INV.SUSPEND_FLG = 'N' AND PS_STOR_LOC_INV.NETTABLE_FLG = 'Y' AND PS_STOR_LOC_INV.PHYS_CYC_INV_FLG = 'N' AND PS_STOR_LOC_INV.WIP_LOC_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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_LOC_INV

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