MG_SER_CONS_VW

(SQL View)
Index Back

Serial controlled consigned vw

mmt 06/00 -- created as a prompt table view for serial controlled consigned items being consumed at op seq = 0

SELECT DISTINCT a.business_unit , b.production_id , c.prdn_area_code , a.inv_item_id , a.inv_lot_id , a.serial_id FROM ps_physical_inv a , ps_sf_prdnid_headr b , PS_SF_PRDN_AREA c WHERE a.business_unit = c.business_unit AND b.business_unit = c.business_unit AND a.business_unit = c.business_unit AND b.prdn_area_code = c.prdn_area_code AND a.qty > 0 AND a.avail_status IN ('1','2') AND ((a.storage_area = c.storage_area AND a.stor_level_1 = c.stor_level_1 AND a.stor_level_2 = c.stor_level_2 AND a.stor_level_3 = c.stor_level_3 AND a.stor_level_4 = c.stor_level_4) OR (a.storage_area = c.non_own_stor_area AND a.stor_level_1 = c.non_own_stor_lev1 AND a.stor_level_2 = c.non_own_stor_lev2 AND a.stor_level_3 = c.non_own_stor_lev3 AND a.stor_level_4 = c.non_own_stor_lev4))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
3 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
4 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
5 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
6 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID