mmt sf800-31.0 created for lot prompt in edit issues for consigned part with op seq <> 0

MG_LOT_WCCNS_VW

(SQL View)
 Index Back

SELECT DISTINCT a.business_unit , a.inv_item_id , b.work_center_code , a.inv_lot_id FROM PS_PHYSICAL_INV a , ps_en_work_center b WHERE 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 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID