PHYS_IN_STAT_VW

(SQL View)
 Index Back

Inventory Summary View/Status


select 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, sum(A.QTY_BASE) from PS_PHYSICAL_INV A, PS_BUS_UNIT_TBL_IN B where a.business_unit = b.business_unit and (a.avail_status = '1' or ((a.avail_status = '2' or a.avail_status = '3') and b.incl_quar_avail = 'Y')) and qty_base <> 0 group by 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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW2

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 TOTAL_BASE_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Base Quantity