MG_SER_WCNS_VW2

(SQL View)
 Index Back

Serial Controlled WC Consigned

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 , a.inv_item_id , b.work_center_code , a.inv_lot_id , a.serial_id FROM PS_PHYSICAL_INV a , ps_en_work_center b WHERE a.business_unit = b.business_unit AND a.qty > 0 AND a.avail_status IN ('1','2') 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) OR (a.storage_area = b.non_own_stor_area AND a.stor_level_1 = b.non_own_stor_lev1 AND a.stor_level_2 = b.non_own_stor_lev2 AND a.stor_level_3 = b.non_own_stor_lev3 AND a.stor_level_4 = b.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 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
3 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
4 COMP_LOT_ID Character(15) VARCHAR2(15) NOT NULL Component Lot ID
5 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID