PHYS_IN_LOT_VW

(SQL View)
 Index Back

Inventory Summary View/Lot


select A.BUSINESS_UNIT, A.INV_ITEM_ID, A.INV_LOT_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_MASTER_ITEM_TBL B where a.avail_status = '1' and a.qty_base <> 0 and a.inv_item_id = b.inv_item_id and b.setid = (select setid from ps_set_cntrl_rec where setcntrlvalue = a.business_unit and recname = 'MASTER_ITEM_TBL') and b.lot_control = 'Y' group by A.BUSINESS_UNIT, A.INV_ITEM_ID, A.INV_LOT_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 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
4 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
5 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
6 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
7 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
8 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
9 TOTAL_BASE_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Base Quantity