APPS.INV_MATERIAL_STATUS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 94: SELECT status_id INTO l_old_status_id FROM mtl_secondary_inventories

90:
91: if p_object_type = 'Z' THEN
92: --Bug 14028205
93: BEGIN
94: SELECT status_id INTO l_old_status_id FROM mtl_secondary_inventories
95: WHERE organization_id = l_status_rec.organization_id
96: and secondary_inventory_name = l_status_rec.zone_code;
97: EXCEPTION
98: WHEN OTHERS THEN

Line 113: update mtl_secondary_inventories

109: ,p_inventory_item_id => l_status_rec.inventory_item_id) ;
110:
111:
112: IF ( l_sub_fl ) then
113: update mtl_secondary_inventories
114: set status_id = l_status_rec.status_id
115: , last_updated_by = l_status_rec.last_updated_by
116: , last_update_date = l_status_rec.last_update_date
117: , last_update_login = l_status_rec.last_update_login